Question
Draw an ER diagram for the exercise and specify the primary key for each entity and the cardinality on both sides of the relationships. A
Draw an ER diagram for the exercise and specify the primary key for each entity and the cardinality on both sides of the relationships.
A hospital has a large number of registered physicians. Attributes of PHYSICIAN include Physician_IDand Specialty. Patients are admitted to the hospital by physicians. Attributes of PATIENT include Patient_IDand Patient_Name. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment. Components of Treatment_Detailinclude Date, Time, and Results.
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