ORDER CUSTOMER

PK Order ID PK Customer ID

FK Customer ID Customer Name

Customer Address

ORDER DETAILS PRODUCT

PK Order ID PK Product ID

Date Product Name

FK Product ID Item Price

Quantity

Total Amount

FK Payment ID

PAYMENT

PK Payment ID

Payment Types

Now that the data is normalized, it takes a bit more work to compile data. Some queries Chuckie needs created are:

$$ List all order numbers, dates, and totals for a supplied customer.

$$ Create a receipt $$ order number, customer, list of items, prices.