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 CA. Part 1: ER Diagram Create an ER diagram for a newly normalized database schema. Part 1: 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. Part 4: Flattening for Analytics Chuckie is really getting in the mood now and wants to run some analytics to make his business even better. To do so he'll need his data flattened, so it is able to be plugged into a tool like Orange. Some of the things he'd like are: The ability to estimate revenue based on information about a customer. Includes the average yearly sales for a customer, along with all of that customer's relevant information . Focus U VIEW Be carefullestrom the Internet can contain viruses. Unless you need to edit it's sales to stay in Protected Erding 09 Dynamite x7, Blueberries, Mangosteens B D 1 Customer Address Date Products Amount Payment Method Notes 2lim Wilson 123 Oak St. 11-Jun-19 Blackberries, CA x3, Fuji Apples 158.6 Visa Elite Demolition (lanet Smit 12452 100 Ave. 25-May-19 Dynamitex? 250 Cheque 19562 Ship All lite orders directly to warehouse this Wayne Johnson 458 Pine Blvd. 28-Jun-19 Cherries X3, Pears 9.76 Cash Jane Thomas 4765 Willow Rd. 01-May-19 04x3 345 Amex DL scanned for ID Elite Demolition (Janet Smit 54 Main St. 03-May-19 Dynamite x7 315 Cheque #1723 Tim Thomas 4765 Willow Rd. 01-Jun-19 CAX3 360 Amex Tommy John 986 Commerce Al 15-Jun-19 Cherries x3, Peaches, Grapes x2 24.16 Cash Elite Demolition (Ryan Tuff) 54 Main St. 07-Jun-19 Dynamite x7, Blueberries, Mang 367 Cash 10% loyalty bonus discount Jim Wilson 123 Oak St. Jun-19 C4, Oranges, Tangerines 134 Visa Radio Shack (Ron Swanson) 11 Birch Crescent 27-Jun-19. Dragonfruit x3, Cherries x6, Man 37.42 Mastercard P.O. 2573 Janet Smith 634 Summit Pt. 11-Jun-19 Cherries x2, Mangoes x5, Mixed 18.45 Cash Loyalty discount from Elite applied
