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

this is a generic structure that works for anything on any DB server

cats:
id numeric
name character

subcats:
id numeric
cid numeric - FK to cats.id
name character

products
id numeric
scid numeric FK to subcats.id
..
rest of product fields

Thx for the suggestion... I will try it^^