Question: ( 3 0 points ) A database system used by a hospital to record information about patients and wards has the following relations: Wards (
points A database system used by a hospital to record information about patients and wards has the following relations: Wardsnumber numBeds Patients pid name, year, gender PatientInWardpid ward Testspatient testDate, test Hour, temperature, heart Rate A ward is identified by its number. Attribute numBeds is the number of beds in that ward. Patients are identified by their personal identification number. The name, year of birth and gender M or F of each patient is stored in the Patients relation. The ward to which each patient is assigned is stored in relation PatientInWard. During their stay in hospital, patients will undergo routine tests. The date and hour of each occasion when these tests are performed on a patient are recorded, and for each of these tests the patient's temperature and heart rate are measured and recorded in the database. A patient will normally undergo these routine tests several times during their stay in hospital. a pts Populate each relation with one sample tuple. b pts Draw the schema for the database system of hospital with complete specifications of primary keys, foreign keys and referential integrity constraints.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
