Draw the four entities that belong on this data model

Assignment Help Computer Engineering

Reference no: EM131165881

UNDERSTANDING THE ELEMENTS OF AN ERD

A wealthy businessman owns a large number of paintings that he loans to museums all over the world. He is interested in setting up a system that records what he loans to whom so that he doesn't lose track of his investments. He would like to keep information about the paintings that he owns as well as the artists who painted them. He also wants to track the various museums that reserve his art, along with the actual reservations. Obviously, artists are associated with paintings, paintings are associated with reservations, and reservations are associated with museums.

QUESTIONS:

1. Draw the four entities that belong on this data model.
2. Provide some basic attributes for each entity, and select an identifier, if possible.
3. Draw the appropriate relationships between the entities and label them.
4. What is the cardinality for each relationship? Depict this on your drawing.
5. What is the modality for each relationship? Depict this on your drawing.
6. List two business rules that are communicated by your ERD.

Reference no: EM131165881

Questions Cloud

Compute the variance for the number of right answers : Compute the variance for the number of right answers when we answer one question with probability .8 of getting the right answer (note that the number of right answers is either 0 or 1, but the expected value need not be). Compute the variance for..

Would you like to switch your choice of curtain : Please answer this question carefully. You have all the tools needed to answer it, but several math Ph.D.'s are on record (in Parade Magazine) giving the wrong answer.

Create the context diagram for the system just described : Create the context diagram for the system just described. Create the DFD fragments for each of the four use cases outlined in part a, and then combine them into the level 0 DFD.

What transpired afterwards be described as inappropriate : Stacey has worked for lawyer Larry for the last five years in his home office. Stacey does everything for Larry - receptionist, bookkeeper, secretary, paralegal, coffee girl, sometimes even taking his laundry to the cleaners. Stacey is smart and v..

Draw the four entities that belong on this data model : Draw the four entities that belong on this data model. Provide some basic attributes for each entity, and select an identifier, if possible. Draw the appropriate relationships between the entities and label them.

Determining the company stock : Schiller Corporation will pay a $2.70 per share dividend next year. The company pledges to increase its dividend by 5.5 percent per year, indefinitely. If you require a return of 12 percent on your investment, how much will you pay for the company..

What is the expected score on a true-false test graded : What must you do to the number of questions to be able to be a certain percent sure that someone who knows 80% gets a grade within 5 points of the expected percentage score?

When it appropriate to involve users in erd creation process : From these two stories, what do you think is the user's role in data modeling? When is it appropriate to involve users in the ERD creation process? How can users help analysts create better ERDs?

Calculate carmen net income : Carmen bought the property in March of 1992, and her basis for depreciation on the house is $110,000. She uses straight-line depreciation with a 27 ½ -year life, so the depreciation on the house is $4,000. Calculate Carmen's net income or loss fro..

User Account

All Pages