troubleshooting Question

Normalization to 3NF; shopping cart data

Avatar of SurfingHamster
SurfingHamster asked on
Microsoft SQL ServerE-Commerce
16 Comments3 Solutions3494 ViewsLast Modified:
Could you normalize all this data (to 3NF) showing the (1) data layout at each stage, (2) the data type it should be set to in MSSQL Server and (3) the relationships of entities by prefixing field names (e.g. PK_UserID) or other appropriate means. I realise it's set out into entities already (I believe this is 1NF - yes?).

1.9.1 Users                  
User ID,      Password,      Telephone Number,      Email Address,
Name,      Company,      Billing Street,      Billing Town,
Billing Postal Town,      Billing County,      Billing Postcode,      Billing Country
Registration Date,      Mailing Subscription

1.9.2 Administrators                  
Admin ID,      Password,      Name,      Last Login

1.9.3 Categories                  
Category ID,      Description      ,   Parent Category,      Default Image,
Category Status

1.9.4 Products                  
Product ID,      Description,      Details,      Price Per Unit
Default Image,      Stock Level,      Shipping Cost,      Lead Time
Product Rating,      Total Ratings

1.9.5 Orders                  
Order ID,      User ID,      Description      ,          Order Date,
NET Total,      Total,      Address,      Shipping Street,
Shipping Town,      Shipping Postal Town,       Shipping County,      Shipping Postcode,
Shipping Country,      Tracking Status,

1.9.6 Billing Details                  
Order ID,        Card Type,      Card Number,      Expiration
CVV Code,       Name on Card,      Card Street,      Card Town
Card Postal Town,      Card County,      Card Postcode,      Card Country

1.9.7 Wish List                  
User ID,      Product ID,             Description,    Price Per Unit

1.9.8 Cart                  
User ID,      Product ID      Quantity

1.9.9 Settings                  
Setting ID,      Store Status
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 16 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros