WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN

WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGN Course: Data Management – Applications – C170 John Smith Western Governors University Student ID # ######## Nora’s Bagel Bin Database Blueprints First Normal Form (1NF) BAGEL ORDER PK Bagel Order ID PK Bagel ID Order Date First Name Last Name Address 1 Address 2 City State Zip Mobile Phone Delivery Fee Bagel Name Bagel Description Bagel Price Bagel Quantity Special Notes A. Nora’s Bagel Bin Database 1.a., 1.b. and 1.c. Nora’s Bagel Bin Database Blueprints (continued) Second Normal Form (2NF) BAGEL ORDER BAGEL ORDER LINE ITEM BAGEL PK Bagel Order ID PK / FK Bagel Order ID PK Bagel ID Order Date 1:M PK / FK Bagel ID M:1 Bagel Name First Name Bagel Quantity Bagel Description Last Name Bagel Price Address 1 Address 2 Each bagel order line has at most one bagel. Each bagel has many bagel order line items. City State Zip Mobile Phone Each bagel order has many bagel order line items. Each bagel order line item has at most one bagel order. Delivery Fee Special Notes 2.a., 2.b. and 2.c. Third Normal Form (3NF) BAGEL ORDER BAGEL ORDER LINE ITEM BAGEL PK Bagel Order ID PK / FK Bagel Order ID PK Bagel ID FK Customer ID 1:M PK / FK Bagel ID M:1 Bagel Name Order Date Bagel Quantity Bagel Description Delivery Fee Bagel Price Special Notes M:1 CUSTOMER Each bagel order line has at most one bagel. Each bagel has many bagel PK Customer ID First Name Last Name Address 1 Address 2 City State Zip Mobile Phone order line items. Each bagel order has many bagel order line items. Each bagel order line item has at most one bagel order. Each bagel order has at most one customer. Each customer has many bagel orders.