Overview

You have been supplied with the sales data from Chuckie's Supplies, a small fruit and explosives

retailer. Being a small store, with a technologically unsophisticated owner, Chuckies keeps their sales

records in on one big Excel spreadsheet. This has been an improvement over the stack of papers in a

shoebox method that it replaced, but recently they have encountered issues with things such as

address changes, returns of only one of many products in a purchase, and changing prices due to

supplier changes. Chuckie needs your help in rescuing his business, to continue supplying the good

neighborhood people with fresh berries and C$4.$

Part $1$: ER Diagram

Create an ER diagram for a newly normalized database schema.

Part $2$: Normalize the Data

Take Chuckie's data and normalize it$.$

Part $3$: Queries

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.