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 C4. 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. G M N Address Date Products Amount Payment Method Notes um Wien 1330 10 cene, per 15 Demon anth) 1752 100 A 25 May 19 Dynamite 17 150 Chee10102 Ship Allt er det to warehouse this dret, not the office on Man Wann Pune 25-19 Cher, Pear 3.70 Cash ane Thomas 4705 Wilowd 01 May 19 64 SASA Danned for Demolition at th) S4 Min 0 May 19 Dynamite 3 Cheque 11421 Tim Thomas 4765 Willow 119 CAN 360 A Tommy lohn 36 Commerce v 15-19 Chem. Peaches Grapes 24.16 Cash Demolition lyan Tulh54 Main St on 10 Oynamite Blueberries. Many 367 Cash 10x loyalty bonus discount 50 W 123OS 19 CA, Orange, Tangerines 114 V- 11 Radio Shack Ron Swanson 11 Birch resant 27-19 Dragant, Charles Mans 37.42 Mastercard 0 V 11 tanetimit 634 Summit 11. un 19 Cherries 2, Mango Mate 18.45 Cash Loyalty discount from the applied 1 10 15 N $ Customer Address Date Products Amount Payment Method Notes 2 Wien 123 Ok 11. 19 Slaberries, Apple 3586 V Demolition Caneth 12452100 25-May 19 Dynamite 150 Cheque 1862 Ship ALLE orders directly to warehouse this address, not the office on Man Wayne con 458 Pined 28:19 Cherries, Pears 9.76 Cash lane Thomas 4765 W May 19 145 Ames Dianned for Dobio lanet Smit) 56 Main St Da May 19 yamtex? 315 Ch 17421 Thom Thomas 4765 Willow 01 Jun 19 C 160 AM Tommy John 986 Commerce 1519 Chemex3. Peaches Grapes 24.16 Cash Demolition Mon Tue S4 Mint 07-ion 10 Oynamite 7. Man 367 Cash 10% lovely bonus discount 10 Wilson 22 Ok 10 C Oranges, Tangerines 134 Visa 11 Gadis Shack on S) 11ch Crest 27- Jurut Cher 6, Mang 17.47 Mastercard 2.0.7573 Summit 11-19 here. Manger Mode 45 C Loyalty discount from lite applied
