Confused on Relationships

[artisticre]

Click on the link to see my question. I am not sure how to make the relations on these databases. Can someone please show me what would be the best way to do this

thanks

http://www.artisticrevolution.com/image1.jpg

[laserlight]

Using '->' to denote one-many and '<->' to denote many-many relationships,
Categories -> Products
Products -> Product Name
Products -> Product Description
Products <-> Product Colors
Products <-> Product Sizes
Products -> Product Prices

So an example database schema might be:

Table: categories
cat_id
name

Table: products
product_id
cat_id
price_id
products_colors_id
products_sizes_id
name
description

Table: colors
color_id
color

Table: products_colors
id
product_id
color_id

Table: prices
price_id
product_id
price

Table: sizes
size_id
size

Table: product_sizes
id
product_id
size_id

Of course, this is just an example based on the information provided, so there are lots of assumptions.
You'll have to refine or even re-work it entirely to suit your actual purposes.