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