# 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 Crow’s Foot ERD that depicts a relational database model to capture these business rules.

### Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

### Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

#### Solutions

Chapter
Section
Chapter 2, Problem 9P
Textbook Problem
245 views

## 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 Crow’s Foot ERD that depicts a relational database model to capture these business rules.

Expert Solution

### Explanation of Solution

(a)

The business rules for PATIENT, ORDER, and MEDICATION can be written as follows.

• A patient can have many medical orders but each order is written for a single patient...
Expert Solution

### Explanation of Solution

(b)

In the Crow’s Foot model by the three-pronged crow’s foot to exhibit the “many” side relationship.

• In this notation, “1”is represented as a short line segment.
• “M” is represented as three-pronged crow’s foot.
• The relationship name is represented above the relationship line...

### Want to see the full answer?

Check out a sample textbook solution.See solution

### Want to see this answer and more?

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

See solution

Find more solutions based on key concepts
Show solutions
How do you translate business rules into data model components?

Database Systems: Design, Implementation, & Management

Air with a density of 0.45 kg/m3 enters an experimental jet engine at rate of 180 m/s. The inlet area of the en...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Convert 10,000 ft-lbf of energy into BTU, Joules, and kilojoules.

Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

solid-state media (376) a. storage method in which the magnetic particles are aligned horizontally around a dis...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

Describe the difference between using a leading and a trailing electrode angle.

Welding: Principles and Applications (MindTap Course List)