4.5 An Example of Patient EER Schema Consider the following information about a patient database: A patient is identified by patient id, and admission date. • A patient must be either an Emergency patient or a resident patient. We must record the checkback date for Emergency patient. Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. • For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need not keep track of its beds any longer. Both emergency patient and resident are cared for by a responsible Doctor. Doctor is identified by Doctor number. For each Doctor, the name, several specialty, and years of experience must be recorded. Doctors prescribe medicine for patients. Medicine is identified by trade name that has scientific name and formula. The medicine depends on another medicine to be taking before. • A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity of medicine. Draw an ER/EER diagram that captures the above information.

C++ Programming: From Problem Analysis to Program Design
8th Edition
ISBN:9781337102087
Author:D. S. Malik
Publisher:D. S. Malik
Chapter13: Overloading And Templates
Section: Chapter Questions
Problem 18PE
icon
Related questions
Question

Consider the following information about a patient database

4.5 An Example of Patient EER Schema
Consider the following information about a patient database:
A patient is identified by patient id, and admission date.
• A patient must be either an Emergency patient or a resident patient.
We must record the checkback date for Emergency patient.
Only resident patient is assigned to one room. Room has a unique number,
degree, and floor number.
• For each room there are a number of beds each of which has a bed number,
specification. If a room is deleted, you need not keep track of its beds any
longer.
Both emergency patient and resident are cared for by a responsible Doctor.
Doctor is identified by Doctor number. For each Doctor, the name, several
specialty, and years of experience must be recorded.
Doctors prescribe medicine for patients. Medicine is identified by trade name
that has scientific name and formula. The medicine depends on another
medicine to be taking before.
• A doctor could prescribe one or more drugs for several patients, and a patient
could obtain prescriptions from several doctors. Each prescription has a date
and a quantity of medicine.
Draw an ER/EER diagram that captures the above information.
Transcribed Image Text:4.5 An Example of Patient EER Schema Consider the following information about a patient database: A patient is identified by patient id, and admission date. • A patient must be either an Emergency patient or a resident patient. We must record the checkback date for Emergency patient. Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. • For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need not keep track of its beds any longer. Both emergency patient and resident are cared for by a responsible Doctor. Doctor is identified by Doctor number. For each Doctor, the name, several specialty, and years of experience must be recorded. Doctors prescribe medicine for patients. Medicine is identified by trade name that has scientific name and formula. The medicine depends on another medicine to be taking before. • A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions from several doctors. Each prescription has a date and a quantity of medicine. Draw an ER/EER diagram that captures the above information.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Transaction Processing
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
C++ Programming: From Problem Analysis to Program…
C++ Programming: From Problem Analysis to Program…
Computer Science
ISBN:
9781337102087
Author:
D. S. Malik
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage