I am developing a mvc app for a carpet company. A carpet's price will depend upon color combinations and size. So to model this scenario i am using 2 tables.
2.CarpetVarients.(For various color and size combinations).
In CarpetVarients table i am thinking about creating columns "Colors", "Size" and "Price" (along other columns). Colors column will store comma delimited colors(like Cream,Red,).
Will this design work? or should i make every combination a different carpet.