VHT2 TASK 1: NORMALIZATION AND DATABASE

VHT2 TASK 1: NORMALIZATION AND DATABASE

DESIGN

Course: Data Management – Applications – C170

John Smith Western Governors University Student ID # ########

1111111111111111111111111111111111111111111111111111111111111111111111111111111111

1111111111111111111111111111111111111111111111111111111111111111111111111111111111

1111111111111111111 1 / 3

John Smith

C170 – VHT2

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 2 / 3

John Smith

C170 – VHT2

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 ORDERBAGEL ORDER LINE ITEM BAGEL

PK Bagel Order IDPK / FKBagel Order ID PK Bagel ID Order Date 1:MPK / FKBagel ID M:1 Bagel Name First NameBagel QuantityBagel Description Last NameBagel Price Address 1 Address 2Each bagel order line has at most one bagel. Each bagel has many bagel order line items.City State Zip Mobile PhoneEach bagel order has many bagel order line items. Each bagel order line item has at most one bagel order.Delivery Fee Special Notes

• / 3