I am designing a database, my first one, for a t-shirt website. I have tables for the individual t-shirts, as well as a linked table for all the colors the shirts come in. They share a "color_id" field that is in both tables.
My question is: what do I do if some of the shirts come in more than one color? How can I design a databse that allows for shirts to have multiple options from the same table???
Any help would be awesome...
Databse design question....
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users