menu
bartleby
search
close search
Hit Return to see all results

Typically, a hospital patient receives medication that have been ordered by a particular doctor. Because the patient often receives several medication 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 MEDICATIONb. Create a Crow's Foot ERD that depicts a relational database model to capture these business rules.

Question

Typically, a hospital patient receives medication that have been ordered by a particular doctor. Because the patient often receives several medication 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.

check_circleAnswer
Step 1

Lets write the business logic first. 

The business rules between PATIENT and ORDER will be.
• A patient can have many (medical) orders written for him or her.
• Each (medical) order is written for a single patient.

Step 2

The business rule between ORDER and MEDICATION will be.

• Each (medical) order can prescribe many medications.
• Each medication can be prescribed in many orders.

Step 3

The business rules refected in the MEDICATION description are:

• Each medication can be presc...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Our solutions are written by experts, many with advanced degrees, and available 24/7

See Solution
Tagged in

Engineering

Computer Science

Relational Databases

Related Computer Science Q&A

Find answers to questions asked by student like you

Show more Q&A add
question_answer

Q: Write a program in c++ to generate a random number between 1 - 100, and then display which quartile ...

A: Program plan:Include the required header files into the program.Define the main function.Declare the...

question_answer

Q: On its own, the number 190 is an example of:

A: On its own, the number 190 is a decimal number.

question_answer

Q: Create a new file in c++.  In this lab, you will add some functionality to the table ofmenu. Your bo...

A: Program Instructions:Declare variables and write a welcome message.Always convert the user's choice ...

question_answer

Q: Cosc 1337 java Perform program setup and initializations- Prompt the user and input the starting Cel...

A: Note: The given program is compiled and executed in "NetBeans IDE"

question_answer

Q: c++ Write a program to swap the contents of two arrays. Each array has five elements. The fist array...

A: Program Instructions:Declare and initialize array and variables.Print the elements of arrays before ...

question_answer

Q: How do I convert a number to octal without using modulus, multiplication, and division. Also, I can'...

A: To convert an integer number to octal without using multiplication, division and modulus or any inbu...

question_answer

Q: how can I write a statement in C++ that would print last name, followed by a comma, followed by firs...

A: Given below is the C++ program to print a statement with last name, followed by comma, followed by f...

question_answer

Q: Which command can you use to determine who is logged in on a specific terminal?

A: Different commands are used to determine who is logged in on a specific terminal. These commands are...

question_answer

Q: Develop the ‘Shape’ application such that: Implement an array of objects of various types (all SIX ...

A: Program plan:Define a class called “ShapeTest”.Define a “main()” method.Create an array of six shape...

Sorry about that. What wasn’t helpful?