Usually one product id will have only one size because the price is based on the size and not on the product id.
So,
Code: Select all
product_id size_id price
A101 MS $12.99
A102 WXL $19.99
...... .... .....
You need to put all attributes on a paper and then decide how to normalize. The ideal way will be to create an entity-relationship diagram or something similar to get rid of a lot of confusion and uncertanity. Either way(whether u create a E-R diagram and then create tables or directly write the table structure) it is going to be a lot of trial and error.