Richard Downe wrote:
I m attempting to model an online t-shirt shop
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.