Monash hospital treats patients who are identified by a unique patient id. When a patient is
admitted to the hospital, the hospital records the patients first and last name, address, date
of birth and emergency contact number (if they are not already on the system). They also
record the date and time of admission. The system needs to maintain a record of all
admissions for a particular patient. When a patient is discharged, the date and time of their
discharge for this admission is recorded.
While in the hospital patients are located in a ward. The ward is identified by a ward code.
Monash Hospital wishes to record the total number of beds in each ward and the number
of currently available (empty) beds. Beds located in a ward are assigned a bed number
within that ward – thus, for example, each ward has a bed number 1. The bedside
telephone number and bed type are also recorded. Beds are classified (their bed type) as
either fixed or adjustable. Not all beds are supplied with a bedside telephone.
During a patient’s admission, they may need to be moved from one bed to another,
possibly in a different ward. If this occurs the date and time the patient is assigned to the
new bed/ward are recorded (a history of all such bed assignments during admission is
While in the hospital each patient is assigned one doctor (identified by a doctor id) as their
supervising doctor. A patient’s supervising doctor may be in charge of many admissions.
The hospital records each doctor’s first and last names and phone number. A doctor may
have one or more specialisations (eg. Orthopaedic, Renal, etc), but not all doctors who
work at the hospital have a specialisation.
During their admission, patients are prescribed procedures as part of their care by doctors.
Procedures consist of tests such as “X-Rays”, “Blood Tests” etc, they also include medical
procedures which might be required such as “Shoulder Replacement”. A patient may have
procedures prescribed by their supervising doctor or any other doctor working in the