Textbook Problem

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.

1. a. Identify the business rules for PATIENT, ORDER, and MEDICATION.
2. b. Create a Crow’s Foot ERD that depicts a relational database model to capture these business rules.