Help in designing my database...

[aguroyz]

Hello,

Can you show me how to best design a database that is exactly the same as this site

http://www.neimanmarcus.com/


I can's seem to organize things..

Here are the tables that I identified:
USERS
PRODUCTS
CATEGORIES(can go infinitely deep)
DESIGNERS
COLORS
SIZES


- 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...

Thanks

[danNL]

Maybe this will help:
http://dev.mysql.com/tech-resources/...alization.html