Reference no: EM132273297

A hospital has rooms for patients. A room may have one or more beds. A patient can be in only one room and on one bed at a time. A bed can only have one patient at a time. A nurse is assigned to a patient. A patient is assigned only one nurse (at a time). A nurse can be assigned to more than one patient, at a time.

a. Identify the entities for this hospital.

b. Identify the relationships between entities and the cardinalities of the relationship.

c. Draw an ER diagram for the hospital.

Think of some relevant attributes for your entities and show them on the diagram.