QUESTION $2$

Given the following business scenario, create a Crow$$s Foot ERD using a specialization hierarchy if appropriate.

Malaca$$ang Medical Center keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient$$s name and date of birth are recorded. Some patients are resident patients $($they spend at least one night in the hospital$)$ and others are outpatients $($they are treated and released$).$ Resident patients are assigned to a room. Each room is identified by a room number. The system also stores the room type $($private or semiprivate$),$ and room fee. Over time, each room will have many patients that stay in it$.$ Each resident patient will stay in only one room. Every room must have had a patient, and every resident patient must have a room.

Make sure to include the attributes stated in the problem and indicate the PKs$,$ and FKs$,$ if applicable. Add attributes that will be logical to add to your identified entities. Share the link to your answer here.