|
I have to create database structure for shopping cart project where i got stuck. Requirements :- 1.) I have one product table that is like tblProduct proId p.k., proName , Qty and i have to maintain some properties of this product that is not fixed like (products T-Shirt have properties colours, size, pattern etc.) these are not fixed bt i have to insert records like T-shirt XL Red 5 bt these properties Size, Colours are not fixed they can more or less so how can i insert them in one table?
(comments are locked)
|
|
Just add the columns to the product table, make them varchar(x) date type. You have a choice of leaving them Null is there is no values, or what I like to do is place NA (for Not Applicable) in the column. The NA value helps with not having to remember to add WHERE Columnname Is Not Null or Is Null to queries. You can see an example of this in the AdventureWorks database from CodePlex. Thanks, Thomas
(comments are locked)
|
