Any ideas on how to model this?

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