Answered step by step
Verified Expert Solution
Question
1 Approved Answer
database Draw ER Diagram for a ward that have three relations ( wards, patients, and operations) The Wards relation stores many data like: ward name,
database
Draw ER Diagram for a ward that have three relations ( wards, patients, and operations) The Wards relation stores many data like: ward name, ward type and the total number of beds in the ward. The Patients relation stores many data like: patient id, name, date of birth and date of admission. The Operations has two attributes: operation code and operation name. assume the following business rules: 1. One Ward may contains many patients or none. 2. A Patient must be allocated in only one ward. 3. A Patient may have do many types of operations, and every operation type may have many patients. Draw the ERD showing cardinality ratio and participation for each relationship 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