Produce an entity relationship model

Reference no: EM13199890

You are required to produce an Entity Relationship Model (diagram) for a very simple electrical utility company prior to a full implementation of a relational database for the company’s activities. Your model should capture the key relationships (mappings) that exist between a small number of Entity Sets. These are provided for you below. In your completed Entity Relationship Model, you should define the Relationship Sets that describe the relationships that exist between the Entity Sets.
Entity Sets
Customers
Call Centres
Repair Departments
Installation Departments
Account Departments
Equipment Departments

Relationships (Mappings)
Many Customers call many Call Centres
Many Call Centres inform a single Repair Department
Many Call Centres inform a single Installation Department
Many Call Centres inform a single Account Department
A single Repair Department visits many Customers
A single Installation Department visits many Customers
A single Account Department deals with many Customers
Many Equipment Departments deal with many Repair Departments

Reference no: EM13199890

Questions Cloud

Calculate the internal rate of return : The loan is to be repaid in seven equal annual installments including interest. The firm's marginal income tax rate is 39%. The equipment qualifies for MACRS 5-year property. a. Calculate the interest on loan for each year.

Define the concepts of socialization and related concepts : Define the concepts of socialization and related concepts? Describe and analyze the models of socialization?

What is the standard error of the mean : CRA CDs, Inc., wants the mean lengths of the "cuts" on a CD to be 135 seconds (2 minutes and 15 seconds). This will allow the disk jockeys to have plenty of time for commercials within each 10-minute segment.

What is the primary source of data for the application : What is the primary source of data for the application? Do alternatives exist? What is the most appropriate scale for the digital map data sets that are to be produced? What are the key considerations in the choice of Datum of the digital map data se..

Produce an entity relationship model : You are required to produce an Entity Relationship Model (diagram) for a very simple electrical utility company prior to a full implementation of a relational database for the company’s activities.

What is the standard error of the mean in the experiment : The Oil Price Information Center reports the mean price per gallon of regular gasoline is $3.79 with a population standard deviation of $0.18. Assume a random sample of 40 gasoline stations is selected.

Difference between motivation and instinct : According to instinct approaches to motivation, people and animals are born preprogrammed with sets of behaviors essential to their survival. How does this explain the difference between motivation and instinct? How does it explain the similarities?

What is present worth of the concept compounded quarterly : The company's computer system uses fluid structure interaction modeling to test and analyze each airbag design concept. What is the present worth of the concept at 16% per year, compounded quarterly, if the quarterly cost in years 1 through 5 is $..

Create cron file that will regularly perform : Create a cron file that will regularly perform the following backups:?

User Account

All Pages