I would like some help modeling an enitiy relationship diagram for a company that has a number of different distributors that they purchase CDs from for resale.

For selling purposes, the CDs are classified by consumer age groups of 4 to 6 years of age; 710 years of age; and 1114 years of age.

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

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?___

The business has hired you to design a relational database.

During the course of your interview with the 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 entity relationship diagram using either Lucid chart, MS Word, MS PowerPoint, MS Excel, or MS Visio