Chapter 2, Problem 2.39PAE

Program Plan Intro

(a) Draw an ERD for the given situation.

Program Plan Intro

(b) Draw an ERD for the given situation:

Program Plan Intro

(c) Draw an ERD for the given situation. Answer the ways in which you model SECTION and the reason for which you choose this way versus alternative ways to model SECTION.

Program Plan Intro

(d) Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time.

Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.

Program Plan Intro

(e) Draw an ERD for the following situation. Make assumption that credit results may not be reused for multiple credit requests and redraw the ERD for this new situation using two entity types, and then redraw it again using one entity type. Name the versions do you prefer among the two and provide reason for same.

Program Plan Intro

(f) Draw an ERD for the given situation and provide the reason for which these different changes to the situation led to different data models, if they did.

Program Plan Intro

(g) Draw an ERD for the given situation.

Program Plan Intro

(h) Draw an ERD for the given situation:

Program Plan Intro

(i) Draw an ERD for the given situation.