Database Case 4: Infant Immunisation


A system is required to record details of infant immunisation in a health region. Every infant in the region is required to have a course of general vaccinations against diseases such as whooping cough and diptheria. Patients are identified by a unique NHS number and details such as the name, date of birth and NHS number of the parent or guardian of the infant are also recorded.

Each vaccination is for a single vaccination type such as mumps, rubella, etc., and is given to a single patient. However, every infant is given a number of booster injections of certain vaccination types at periodic intervals. The date of each vaccination is recorded.

Vaccination are given by General Practitioners (Gps). A general practice usually has many GPs. Each GP works for only one general practice and usually has many patients on his or her list. Each infant is on the list of only one doctor. Practices are identified by practice names and GPs are identified by unique GP numbers. The name of each doctor and the number of vaccination patients on each doctor’s list also needs to be recorded.

Besides general update operations, the following processes must be supported by the system:


The production of appointment letters
A work-list by General Practice for a given week
An audit list indicating the number of vaccinations by type conducted during the previous six-month period

Last updated: April 2000

Return to Database Systems Page