College of St Joseph Doctors and Outpatient Diagram EDR Paper

1.

Here are the requirements for this exercise :

• A health care organization keeps track of its doctors and outpatient locations
• For each doctor it keeps track of the DoctorID (unique), DoctorName, and DoctorYearOfMDGraduation (year of graduating from medical school)
• For each outpatient location(OL) it keeps track of the OLID (unique) and OLName

Using the requirements given above complete the following:

1.(a) ERD1:M relationship, where participation on the 1 side is mandatory and participation on the M side is optional

(b) Relation – For 1(a) showseveral records in each relation and mark those values that indicatemandatory participation on the 1 side and those that indicate optionalparticipation on the M side

Answer to this has already been provided in the Sample Solution provided

2. (a) ERD 1:M relationship, where participation on the 1 side is optional and participation on the M side is mandatory.

(b)Relation – For 2(a) show several records in each relation and markthose values that indicate optional participation on the 1 side andthose that indicate mandatory participation on the M side.

3. (a) ERD –1:M relationship, where participation on both sides is mandatory

(b)Relation – For 3(a)show several records in each relation and mark thosevalues that indicate mandatory participation on the 1 side and thosethat indicate mandatory participation on the M side

4. (a) 1:M relationship, where participation on both sides is optional

(b)For 4(a) show several records in each relation and mark those valuesthat indicate optional participation on the 1 side and those thatindicate optional participation on the M side.

5(a) M:N relationship, where participation on one side is mandatory and participation on the other side is optional

(b) For 5(a), show several records in each relation and mark those values that

indicate mandatory participation on one side and those that indicate optional participation on the other side

6(a) M:N relationship, where participation on both sides is mandatory

(b) For 6(a), show several records in each relation and mark those values that

Indicate mandatory participation on one side and those that indicate mandatory participation on the otherside.

7(a) M:N relationship, where participation on both sides is optional.

(b) For 7(a), show several records in each relation and mark those values that

indicate optional participation on one side and those that indicate optional participation on the other side.

8(a) 1:1 relationship, where participation on one side is mandatory and participation on the other side is optional

(b)For 8(a), show several records in each relation and mark those valuesthat indicate mandatory participation on one side and those thatindicateoptional participation on the other side.

?? Must be done by MS word.