Creating an ER diagram for a Normalized Database Schema

Introduction to Normalizing a Small Business' Sales Data

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.

Create an ER diagram for a newly normalized database schema.Now that the data is normalized, it takes a bit more work to compile data. Some queries Chuckie needs created are.

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:

• Describe 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.