Database Management project.

ADhomework
Sales_Order_fixed.docx

 

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

Unit Price

Line Total

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

 

Subtotal

$53.50

Sales Tax

10%

Total

$58.85

Special Handling Notes:

 

Please include plates and napkins.

 

] Thank you for your business!