1st and 2nd Normal Forms (Relational Database)

User Generated

Cnee

Computer Science

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.pdf

Unformatted Attachment Preview

Sales Order Donuts-R-Us Date: May 6, 2014 You eat them fresh, we bake them fresh. Donut Order ID: [1] Customer ID: [1] Customer: [First Name] [Last Name] [Street Address] [Apt. #] [City, ST ZIP Code] [Home Phone] [Mobile Phone] [Other Phone] Qty Donut ID Name Description 1 1 Plain Plain Donut $1.50 $1.50 5 2 Glazed Glazed Donut $1.75 $8.75 12 3 Cinnamon Cinnamon Donut $1.75 $21.00 3 4 Chocolate Chocolate Donut $1.75 $5.25 4 5 Sprinkle Sprinkle Donut $1.75 $7.00 5 6 Gluten-Free Gluten-Free Donut $2.00 $10.00 Special Handling Notes: Please include plates and napkins. ] Thank you for your business! Unit Price Line Total Subtotal $53.50 Sales Tax 10% Total $58.85
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags