Database Management project.

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!