VHT2 TASK 1: NORMALIZATION AND DATABASE DESIGN Course: Data Management – Applications – C170 John Smith Western Governors University Student ID # ######## 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 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 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 City line items. State Zip Mobile Phone Each bagel order has many bagel order line items. Each bagel order line item Delivery Fee has at most one bagel order [Show More]
Last updated: 2 years ago
Preview 1 out of 17 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Can't find what you want? Try our AI powered Search
Connected school, study & course
About the document
Uploaded On
Sep 13, 2022
Number of pages
17
Written in
This document has been written for:
Uploaded
Sep 13, 2022
Downloads
0
Views
150
In Scholarfriends, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Scholarfriends · High quality services·