Overview You are given the data for the sales that occur at Leos Supplies. This supply store provides a wealth of goods, but specializes in the sale of small fruits and, curiously, explosives. Being a small store, Leos keeps their sales records in a big Excel spreadsheet. However, they have recently encountered issues with address changes, returns of products in a purchase, and fluctuating prices due to supplier changes. Leo needs your expertise saving his business in order to maintain his lucrative market of fresh berries and explosives.

Part 1: Normalize the Data Take Leos data and normalize it.

Part 2: ER Diagram Create an ER diagram for a newly normalized database schema. (It only has to be for this initial version of the normalized database, not the one afterwards with the additions in Part 4)

Part 3: Queries Now that the data is normalized, it takes a bit more work to compile data. Some SQL queries Leo needs created are: List all order numbers, dates, and totals for Elite Demolition. List the payment Method(s) used by Wayne Johnson Create a receipt order number, customer, list of items, prices and date. (Remember JOINS)

Part 4: Updates Now that Leos data has been saved, he would like to adjust it a little bit to make room for more products. Adjust the tables again to include a separate table for both explosives and fruits. Including a descriptions attribute section for both tables. (Add in your own generic information for this section.)

Part 5: Flattening for Analytics Leo is really getting in the mood now and wants to run some analytics to make his business even better. To do so hell need his data flattened, so it is able to be plugged into a tool like Orange. Some of the things hed like are: The ability visualize the relationships between the Customers and products bought. Specifically: o Customers versus Fruit products o Customers versus Explosive products This method to visualize data in Orange is up to you, but you can be as creative as you want with it.