Database Design Question - any suggestion?

He wants an article number for each item of clothing.

However each item of clothing has a size (s/m/l) and a possible range of colours. He wants to be able to keep track of the stock for each size and colour but he only wants an article number for each style.

For example:

Article No. 001 - Mens T-Shirt (small:white) 
                  Mens T-Shirt (medium:white)
                  Mens T-Shirt (large:white) 

Article No. 002 - Mens Jeans (small:blue) 
                  Mens Jeans (medium:blue)
                  Mens T-Shirt (large:blue)

Obviusly the Article No. will be the primary key, but how best to store data about each colour and size combination, and what is a new item comes into stock in a new colour?

Any pointers or suggestions would be appreciated.

Many thanks,

Rob Burne. Received on Sun Dec 05 2004 - 17:41:17 CET