Question: This exercise is based on the three Presentation Layer ER diagrams that follow. a. Describe what is reflected by the entity types and relationship types

This exercise is based on the three Presentation Layer ER diagrams that follow.
This exercise is based on the three Presentation Layer ER
This exercise is based on the three Presentation Layer ER
This exercise is based on the three Presentation Layer ER

a. Describe what is reflected by the entity types and relationship types in Presentation Layer ER diagram number 1. In other words, please tell the basic facts of the story. An explanation of the various attributes need not be part of your story.
b. How do the basic facts of the story change with the change noted in Presentation Layer ER diagram number 2?
c. How many data sets would be required to illustrate the nature of the information requirements in Presentation Layer ER diagram number 1?
d. What would be the name and attributes associated with each data set identified in question (c)?
e. Using Presentation Layer ER diagram number 1, assume there are four clinic owners, at least one of which is a physician and at least one of which is a medical corporation. How many entities (instances of each entity type) would appear in the MEDICAL_CORPORATION, PHYSICIAN, and CLINIC_OWNER data sets? It is possible that there may be more than one correct answer to this question.
f. How would your answer to question (e) change if it was based on illustrating the difference between Presentation Layer ER diagram number 1 and Presentation Layer ER diagram number 2? Please justify your answer.
g. Discuss how the basic facts of the story change if the story is based on Presentation Layer ER diagram number 3.

Gender STOCKHOLDER CLINIC-ONNER MEDICAL 2 NetWorth Gender CLINIC_ OWNER Only Change MEDICAL Epeciailty ste Networth STOCKHOLDER Ne spec alty salary - CoreName Headquarters . MEDICAL CORPORATION PHYSICIAN QanedR O CLINICOWNER

Step by Step Solution

3.45 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a A clinic owner is either a medical corporation or a physician Each medical corporation for which w... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

887-CS-DB (2131).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!