A Company has a number of distributors from whom they purchase the CDs for resale.

For selling purposes, the CDs are classified by appropriate age groups: 46; 710; and 1114.

Roughly 30% of total sales occur within their single retail store; the remaining 70% are through mail order.

Sales are particularly strong during the summer vacation months and Christmas shopping season. When the business opened, Ted created a simple computerized database to handle customer orders and sales. A data form is filled out every time a customer places an order, and includes the following:

DATA ENTRY FORM Customer number ____________ Order date ___________

First name _________________ Last name __________________ Street _____________________ City, State, Zip ___________ ____________________________ Phone: ( )__________

CD number ____________ CD Title ___________________ ____________________________ Price $________ CD shipped?___

As the business has grown, so too has the Martins realization that their simple database has become something of a liability. The database is filled with duplicate data, and deleting unwanted data is nearly impossible because good data is deleted along with it. Stories on CD, Inc. has hired you to design a relational database to resolve these and other problems that plague the database. During the course of your interview with the Martins about their business, several additional things come to light that affect how you will design the database: Additional things that affect how you will design the database:

1. The Company offers its customers a purchasing incentive: all CDs are always discounted 40% from the retail price.

2. The Company likes to store the names of potential customers, even if theyve never done business with them.

3. All information about current distributors is kept on Rolodex cards.

4. Three times each year, the Company sends out 56 page brochures to advertise their top-selling and latest-release CDs, including general descriptions of each CD (primarily the names of the stories).

5. The Company does not accept customer orders outside of the U.S.

6. The Company does not use distributors outside of the U.S.

Deliverable: An ER Diagram using either Lucid chart, MS Word, MS PowerPoint, MS Excel, or MS Visio lucid chart.