C170
Western Governor University
WGU Student ID#
,
, Part A
Nora’s Bagel Bin Database Blueprints
The fact that Bagel order form for Nora’s Bagel Bin was already provided in the first normal form of database. It is imperative that
the database to be normalized in order to provide more efficient database and additional functionalities and features.
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
Western Governor University
WGU Student ID#
,
, Part A
Nora’s Bagel Bin Database Blueprints
The fact that Bagel order form for Nora’s Bagel Bin was already provided in the first normal form of database. It is imperative that
the database to be normalized in order to provide more efficient database and additional functionalities and features.
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
