Identify different entities from this scenario.Create an entity-relationship diagram illustrating 1:1 and 1: many relationships.

Scenario:

Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M relationship between patient and order. Similarly, each order can include several medications, creating a 1:M relationship between order and medication.

Identify different entities from this scenario.

Create an entity-relationship diagram illustrating 1:1 and 1: many relationships.

Compare your ERD with another classmate’s and discuss the differences each of you had.