Considering the following requirements and constraints:

A$.$ The hospital is organized into departments $($DEPARTMENT$),$ and each

department has a unique identifier, a name, and a particular member

$($physician$)$ who is the head of the department.

B$.$ The department consists of a number of physicians $($PHYSICIAN$),$ patients

$($PATIENT$),$ and nurses $($NURSE$).$ The physician has an identifier $($unique$),$

name, phone number, and address. The physician makes an appointment

$($APPOINTMENT$)$ to examine a patient. After the examination of the patient,

the physician can appoint a treatment $($PROCEDURE$)$ with date and notes,

and prescribe medication $($MEDICATION$)$ with prescription duration $($start and

end date$).$

C$.$ The patient has an id $($unique$),$ name $($first name and last name$),$ address,

phone, and insurance code.

D$.$ The patient can take a test $($TEST$)$ at the hospital with a recorded id$,$ date,

type $($e$.$g$.,$ COVID test, allergy test, etc.$),$ and test result.

E$.$ The appointment has information about the appointment, patient, nurse, and

physician who made the appointment, with a start date and end date $($when

the appointment is finished$),$ as well as the examination room $($ROOM$).$ The

room has a unique number, type, and availability status $($Available$/$Busy$).$

F$.$ The nurse has an id $($unique$),$ name, phone number, and specialization $($e$.$g$.,$

pediatric nurse, oncology nurse$).$ The nurse can be on call to a specific

examination room with a tracked start and end time of the call.

G$.$ Medication has id$($unique$),$ atc code, name, type $($e$.$g$.,$ pills, drops, cream$),$

and description.

H$.$ The procedure prescribed to the patient has a code$($unique$),$ name, and cost Design an ER schema for the hospital database based on the information above

The ER schema should contain entities with their corresponding attributes, key attributes of

each entity, only binary relationships, their corresponding cardinality ratio, and participation

constraints $($total$/$partial$).$