Hi Richard,
Richard Downe wrote:
I m attempting to model an online t-shirt shop
<snip>
My most recent data modeling attempt consists of 3 tables and respective columns: 1. designs - name, description, picture, price. 2. color - color, design_id 3. size - size, color_id
The model associations are:
... largely irrelevant until you have all the models you need. If you're modeling a t-shirt shop, one might expect a t-shirt model. That might have a quantity-on-hand attribute. Of course, that's just one way to look at it.
hth, Bill