$6.(20$pts$)$You are hired to set up a relational database for a hospital.

Below are the facts of the hospital$$s data.

$*$ Every hospital room has a unique room number and a designated usage.

$*$ Every patient has a unique patient number and a name. Different patients may

have the same name.

$*$ Each patient is assigned to one hospital room. Each room can have multiple

patients.

$*$ Each doctor has a unique doctor ID$,$ a name, and a unique phone number.

Some doctors may have the same name.

$*$ Each patient can be treated by more than one doctor. Each doctor can attend to

more than one patient.

$*$ After the doctor treats a patient, he$/$she will write a report. Each report has a

unique report number and a date.

$*$ Each patient can have multiple treatments by the same doctor. In other words,

each $($doctor$,$ patient$)$ pair can be associated with multiple reports. However,

each report will be associated with only one $($patient$,$ doctor$)$ pair.

Draw the ER Diagram for the hospital.