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