Draw an ER diagram for the following medical database. Make sure you show the participation ratios $($partial or single lines$),$ the cardinality of each relationship $($by showing the $1$ or the N$),$ and the $($min$,$max$)$ ratios for as many relationships as you have information for. If any assumptions, please state what you are assuming.

Here is the write$-$up of the medical database.

Need to keep information about doctors, patients, insurance, and doctor's dependents.

A doctor may see a patient and can see up to many patients. A patient must be seen by a doctor and can only be seen by up to $2$ doctors.

A doctor may have several dependents.

A patient may have insurance, and insurance has to belong to a patient.

For every doctor we keep their area of specialization, name, ssn$,$ address, phone.

The ssn will be used to uniquely identify the doctor. The name can also be used to uniquely identify the doctor.

For every patient keep: name, ssn$,$ address, phone, age, sex. And, the ssn will be used to uniquely identify the patient.

For every insurance keep the name of the insurance, insurance$\_$id$,$ insurance$\_$coverage; and, the insurance$\_$id will be used to uniquely identify the type of insurance.

The insurance premium will be based on the patient as well as the insurance.

Patient:

Attributes: PatientID $($PK$),$ Name, ContactInfo, Address, Age, Weight, Height, InsuranceInfo, SSN$.$

Candidate Key: PatientID.

Doctor:

Attributes: DoctorID $($PK$),$ Name, Specialization, ContactInfo.

Candidate Key: DoctorID.

Room:

Attributes: RoomNumber $($PK$),$ RoomType, Availability.

Candidate Key: RoomNumber.

Staff:

Attributes: StaffID $($PK$),$ Name, Role, ContactInfo.

Candidate Key: StaffID.

Treatment:

Attributes: TreatmentID $($PK$),$ TreatmentDetails, Date, StaffID $($FK$),$ PatientID $($FK$).$

Candidate Key: TreatmentID.

Relationship Sets:

Patient$-$Doctor:

Descriptive Attributes: None.

Associated Entities: Patient, Doctor.

Cardinality Constraints: One$-$to$-$Many $($One patient can be assigned to one doctor, one doctor can have many patients$).$

Participation Constraints: Total participation on the patient side, partial on the doctor side.

Patient$-$Room:

Descriptive Attributes: AdmissionDate, DischargeDate.

Associated Entities: Patient, Room.

Cardinality Constraints: One$-$to$-$One $($One patient is assigned one room, one room can be assigned to one patient at a time$).$

Participation Constraints: Partial participation on both sides.

Patient$-$Treatment:

Descriptive Attributes: None.

Associated Entities: Patient, Treatment.

Cardinality Constraints: One$-$to$-$Many $($One patient can have multiple treatments, each treatment is for one patient$).$

Participation Constraints: Total participation on the treatment side, partial on the patient side.

Staff$-$Treatment:

Descriptive Attributes: None.

Associated Entities: Staff, Treatment.

Cardinality Constraints: One$-$to$-$Many $($One staff member can perform multiple treatments, each treatment is performed by one staff member$).$

Participation Constraints: Partial participation on both sides. $($should be a flowchart like the picture$).$