Description
Hello,
Issue of Concern:
I am having trouble with my 1st and 2nd normal forms for the following non-normalized form:
DONUT ORDER TABLE
Donut Order ID
Donut ID
Date
Customer ID
First Name
Last Name
Street Address
Apt
City
State
Zip Code
Home Phone
Mobile Phone
Other Phone
Donut Name
Donut Description
Quantity
Unit Price
Special Handling Notes
Please assist me attain the correct formation of the 1st and 2nd normal forms along with the primary and foreign keys.
The information is based on the attached Sales Order form.
Thank You in Advance
Donuts-R-Us Sales Order Form.pdfUnformatted Attachment Preview
Purchase answer to see full attachment