troubleshooting Question

Normalization to 3NF; shopping cart data

Avatar of SurfingHamster
SurfingHamster asked on
E-CommerceMicrosoft SQL Server
16 Comments3 Solutions3496 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
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 3 Answers and 16 Comments.
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>


Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 3 Answers and 16 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004