Help in designing my database...
Can you show me how to best design a database that is exactly the same as this site
I can's seem to organize things..
Here are the tables that I identified:
CATEGORIES(can go infinitely deep)
- products can have one or more colors and designers
- one size can have on or more colors
- designers belongs to one or more categories
Please help me with this..
I can't seem to decide how connect all relationships of my tables...