In SQL Server you must have a field that uniquely identifies each row ... let's go back to the Size & Color issue. Let's say that Sue orders 3 T-shirts: one small blue, one medium red, and one large ...
Products Table - holds product information like product name, description, size, color ... 7.0 Here is a sample E-commerce application database structure. For a relational database to work properly ...