Typically, a hospital patient 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.

a.) Identify the business rules for PATIENT, ORDER, and MEDICATION.

b.) Create a Crows Foot ERD that depicts a relational database model to capture these business rules.