menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

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.

BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900
Chapter 2, Problem 9P
Textbook Problem
41 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.

  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.

Explanation of Solution

(a)

Business Rules:

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...

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...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

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

Get Started

Chapter 2 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add
Ch. 2 - What is a relationship, and what three types of...Ch. 2 - Give an example of each of the three types of...Ch. 2 - What is a table, and what role does it play in the...Ch. 2 - What is a relational diagram? Give an example.Ch. 2 - What is connectivity? (Use a Crows Foot ERD to...Ch. 2 - Describe the Big Data phenomenon.Ch. 2 - What does the term 3 Vs refer to?Ch. 2 - What is Hadoop, and what are its basic components?Ch. 2 - What are the basic characteristics of a NoSQL...Ch. 2 - What is logical independence?Ch. 2 - What is physical independence?Ch. 2 - Use the contents of Figure 2.1 to work Problems...Ch. 2 - Use the contents of Figure 2.1 to work Problems 13...Ch. 2 - Use the contents of Figure 2.1 to work Problems 13...Ch. 2 - Using Figure P2.4 as your guide, work Problems 45....Ch. 2 - Using Figure P2.4 as your guide, work Problems 45....Ch. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Typically, a hospital patient receives medications...Ch. 2 - United Broke Artists (UBA) is a broker for...Ch. 2 - Using the ERD from Problem 10, create the...Ch. 2 - Convert the ERD from Problem 10 into a...Ch. 2 - Describe the relationships (identify the business...Ch. 2 - Create a Crows Foot ERD to include the following...Ch. 2 - Write the business rules that are reflected in the...Ch. 2 - Create a Crows Foot ERD for each of the following...Ch. 2 - Write the business rules that are reflected in the...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is (are) the major alloying element(s) in 8730 steel?

Precision Machining Technology (MindTap Course List)

As an engineer working for a water bottling company, you collect the following data in order to test the perfor...

Engineering Fundamentals: An Introduction to Engineering (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)

What is meant by font style? (166)

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

What produces the heat during a shielded metal arc weld?

Welding: Principles and Applications (MindTap Course List)