• E3.5a) Map the ER diagram created in exercise E.2.2a into a relational schema.

  II) Show several records in each relation and mark those values that indicate mandatory participation on the 1 side and those that indicate optional participation on the M side.

• E3.5b) Map the ER diagram created in exercise E.2.2b into a relational schema.

  II) Show several records in each relation and mark those values that indicate optional participation on the 1 side and those that indicate mandatory participation on the M side.

E2.2b Additional requirement Each doctor works at either one outpatient location or at none (strictly working in the main hospital), and each outpatient location must have at least one but can have many doctors working at it. DoctorName OLID OLName DoctorID DoctorYearof MDGraduation DOCTOR WorksAt OUTPATIENT LOCATION E2.2a Additional requirement Each doctor works at exactly one outpatient location, and each outpatient location can have between none (rchab and minor health issues only) and many doctors working at it. DoctorName OLID OLName DoctorID DoctorYearof MDGraduation DOCTOR DO WorksAt th OUTPATIENT LOCATION E2.2b Additional requirement Each doctor works at either one outpatient location or at none (strictly working in the main hospital), and each outpatient location must have at least one but can have many doctors working at it. DoctorName OLID OLName DoctorID DoctorYearof MDGraduation DOCTOR WorksAt OUTPATIENT LOCATION E2.2a Additional requirement Each doctor works at exactly one outpatient location, and each outpatient location can have between none (rchab and minor health issues only) and many doctors working at it. DoctorName OLID OLName DoctorID DoctorYearof MDGraduation DOCTOR DO WorksAt th OUTPATIENT LOCATION