Nora’s Bagel Bin Database Blueprints (continued)

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 PK / FK Bagel ID Bagel Description
First Name Bagel Quantity Bagel Price
Last Name Bagel Name
Address 1
Address 2
City
State
Zip
Mobile Phone
Delivery Fee
Special Notes



• Separate the data that depend on just one of the two parts of the primary key into separate tables.
• Keep any columns in the original table (now named "Bagel Order Line Item") that still depend on both parts
of the original primary key.
• Fill in each shaded cell within the tables with an attribute from the 1NF blueprint in the previous section.
• Fill in the dotted cells between the tables with the cardinality of the relationship between those two tables:
one- to-one (1:1), one-to-many (1:M), many-to-one (M:1), or many-to-many (M:M).




This study source was downloaded by 100000851646087 from CourseHero.com on 11-23-2022 03:27:01 GMT -06:00


https://www.coursehero.com/file/117788191/Noras-Bagel-Bin-Database-Blueprintsdocx/