Stories on CD, Inc.: Case Study

In 2008, Ted Turner and Lisa Marie opened Stories on CD Company, Inc., a family-owned business that sells audio CDs of classic and best-selling children's stories. 

The 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: 4–6; 7–10; and 11–14.  

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 orders the company placed with its distributors. 
A data form is filled out every time Stories on CD places an order, and includes the following:

DATA ENTRY FORM
 Distributor Number ____________	Order date ___________   	
 Distributor name ______________		
 Street __________________		
 Suite _____________________		
 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 Martin’s about their business, several additional things come to light that affect how you will design the database:

1.	The Company likes to store the names of “potential” distributors, even if they’ve never done business with them.

____________________________________________________________________________
2.	Three times each year, the Company creates lists of the CDs it has ordered and notes which distributors process orders quickly.
____________________________________________________________________________

3.	The Company does not currently use distributors outside of the U.S., though it might choose to do so to capitalize on the growing market for CDs in languages other than English.
____________________________________________________________________________