|
hi guys, i m need help in database design for cosmetics. i m using sql server 2005.
first, my product categorize by area ==> face, eyes, lips
and each category hv sub categories
face ==> foundation, powder, concealer, etc.
eyes ==> eye shadow, eye liner, etc.
lips ==> lipstick, lip gloss, etc.
under sub categories, there are many product with different brand.
I might using this database for DSS feature as well. helping user to choosing product base on what they select.
Any idea how i m going to design the database?
Thanks...
|