Answer Happy

Objective:
Enable the student to design and
develop a database. In this project, the student are required to
show their abilities of:
Case Brief
THE IVOR PAINE MEMORIAL HOSPITAL
1. Introduction
The Ivor Paine Memorial Hospital wishes to develop a database
system. The hospital is organized in the following way.
There are number of wards each of which contain a number of
patients. A patient may be assigned to only one ward. Each ward has
a unique name. Wards cater for certain specialties e.g.,
orthopedic, geriatric etc. A ward may cater for only specialty but
a specialty may be treated on more than one ward.
Working on each wards are number of nurses: a day sister, a
night sister, a number of staff nurses and a number of
non-registered nurses. A nurse works on one ward only. On a ward
patients are grouped into care-units. Each care-unit has a unique
number within the hospital. For each care-unit a group of nurses is
allocated to care solely for the patients in that particular
care-unit. A staff nurse is in charge of each care-unit. A nurse is
only ever involved with a single care unit. A patient can only
belong to one care unit.
In the hospital there are number of doctors, a few of which hold
the position of consultant. Each consultant has a single specialty
although there may be a number of consultants with an identical
specialty. Each consultant has a team of doctors. A doctor can
belong to only one team at a time. A patient is in the charge of
just one doctor but may receive treatment from more than one doctor
depending on the type of complaint(s) the patient may have.
At present the hospital has a manual record system but this
needs rationalization. It is hoped that the new computerized system
will remove data redundancy that at the same time service the
information needs of the various user groups in the hospital.
2. The
following manual records are kept:
All medical staff uses the following patient record. A patient
can have a number of complaints at the same time and can receive a
number of different treatments for the same complaint over a period
of time. However at any given time for a particular complaint a
patient can only be treated by one doctor and can only receive one
type of treatment for that complaint.
Form: Input Patient No
IVOR PAINE MEMORIAL HOSPITAL
PATIENT RECORD
Patient
No:
Doctor No:
Doctor Name:
Consultant:
Patient
Name:
Date of Birth:
-----------------------------------------------------------------------
Medical History
Complaint Treatment Doctor
Date Treatment Date
treatment
Code Code

Started
Ended
For administrative purposes the following record is kept for
each ward. Each bed in the hospital has a unique number. When a
patient is discharged his/ her entry is crossed off the record.
Form & Report: Input Ward Name (List Item)
IVOR PAINE MEMORIAL HOSPITAL
WARD RECORD
Ward
Name:
Specialty:
Day Sister:

Night sister:
Staff
Nurses:
Non-registered Nurses:
-----------------------------------------------------------------------
Patient Information
Patient Patient
Care Bed Consultant
Date Admitted
No
Name Unit
No
Each consultant keeps the following record about each of the
doctors in his/ her team. Possible positions are students(s),
junior houseman(jh), senior houseman (sh), assistant registrar(ar)
and registrar(r). The record is used to monitor performance. Every
six months the consultant assigns a performance grade to the
doctor.
Form: Input Staff No
IVOR PAINE MEMORIAL HOSPITAL
CONSULTANT TEAM RECORD
Staff
No:
Name:
Position:

Date joined team:
-----------------------------------------------------------------------
Previous
Experience
From To Position
Establishment
Date Date
Progress
Date Performance Grade
The following reports/ queries are needed:
Document inclusive of following items
in appropriate format