Question
1. When a patient is booked into the system, it is typcially associated with multiple appointments. An appointment has a startdate time, duration, actual startdate,
1. When a patient is booked into the system, it is typcially associated with multiple appointments. An appointment has a startdate time, duration, actual startdate, actual duration, columns for maintaining whether the patient has an emergency condition(is_emerg), whether a confirmation is required (is_confirm). Examples of appointments include (CTScan, Mammograms). Obviously depending the type of procedure to be done during the appointment, a resource unit is involved. The list of resource units is maintained along with associated columns such as resunit_id, cost center, managerid, and manager phone number.
For this problem:
write a line (one-liner) indicating the nature of relationship,
draw an ER diagram clearly delineating all columns and Primary keys and Foreign keys,
decide on the number of tables needed, and
four accompanying statements of maximum and minimum cardinality.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started