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 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.
 
 
 

Transcribed Image Text:

NetWorth Gender STOCKHOLDER Address Cunere CLINIC_OWNER Owns CamName Headquarters MEDICAL CORPORATION PHYSICIAN Speciality Balary NetWorth Gender STOCKHOLDER Address Cunere CLINIC_OWNER Owns CamName Headquarters MEDICAL CORPORATION PHYSICIAN Speciality Balary