1. When a patient is booked into the system, it is typcially associated with multiple appointments. An appointment has a startdate time, duration, actual startdate, actual duration, columns for maintaining whether the patient has an emergency condition(is_emerg), whether a confirmation is required (is_confirm). Examples of appointments include (CTScan, Mammograms). Obviously depending the type of procedure to be done during the appointment, a resource unit is involved. The list of resource units is maintained along with associated columns such as resunit_id, cost center, managerid, and manager phone number.

For this problem:

write a line (one-liner) indicating the nature of relationship,

draw an ER diagram clearly delineating all columns and Primary keys and Foreign keys,

decide on the number of tables needed, and

four accompanying statements of maximum and minimum cardinality.