1. Draw a new ER model that resolves the following M:M Relationship between CUSTOMER and PRODUCT and adds the attributes date ordered, quantity ordered, and price.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

2. Draw a new ER model using a recursive structure (entities, attributes and relationships) for the following information requirements:

"We have a company that sells widget throughout the US.  It is divided in 6 major sales regions - Northeast, Southeast, Midwest, Northwest, South and Southwest.  Each Region has a unique region code. Each sales region is then divided into several sales districts.  For example, the Midwest Region is divided into the Great Lakes, Far North, Mississippi Valley and Farm Belt  Districts.  Each district has a unique district code.

Each district is made up of sales territories. The Great Lakes District is composed of Detroit Toledo, Chicago Milwaukee territories.  Each territory has a unique territory code. Then each sales territory is broken down into sales areas. For example, Chicago Milwaukee is made up of four sales areas: the Loop, the S-burbs, Ohare, N-Burbs and the Mil-Shore sales areas. Each sales area has a unique sales area code."

The domain for Region code, District Code, Territory code and Sales Area Code is identical.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

3.  Draw a new ER model using subtypes and supertype (entities, attributes and relationships) for the following information requirements:

"A business has defined two types of customers: profit and non-profit. For all customers,
track each customer's number, business name, contact name, and assigned salesperson. For the
profit customers, also track mark-up rate and tax rate. For the non-profit customers, track the discount rate and their relationship to the volunteers."

Create three entities: SALESPERSON, VOLUNTEER and CUSTOMER (CUSTOMER is a supertype with two subtypes).  Each CUSTOMER is either an PROFIT CUSTOMER or a NON-PROFIT CUSTOMER.  You also should have two relationships: One between CUSTOMER and SALESPERSON and one between NON-PROFIT CUSTOMER and VOLUNTEERS.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

4. Draw a new ER model using arcs (entities, attributes and relationships) for the following information requirements:

"The accounting firm of Dewy Cheatem and Howe has two types of clients: corporations and individuals.  Projects are tasks that accountants are assigned for a client on a specific date.  Each project has it own number and its own project leader.  When a project is put in place that project can be assigned to only one of those types of clients.  Corporations have information about their name, address, state and corporate tax id.  Individuals have social security numbers, first and last names, home addresses, work addresses, number of dependents and email address."