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 the business rules for PATIENT, ORDER, and MEDICATION. You can paste the text for your business rules Create a Crow’s Foot ERD that depicts a relational database model to capture these business rules.
