Activity : Files, Records, Fields
In a hospital, a file of patients details is stored on a computer.
Part of this file is shown here :
PatientID
Name
Illness
Doctor
WardID
DOB
65349
Tom Jenkins
Mumps
Dr. Thomas
W1
16/11/94
65350
Ann Crombie
Asthma
Dr. Jones
W3
03/06/84
65352
David Walsh
Hip fracture
Dr. Thomas
W1
21/04/51
65353
Jenny Smith
Asthma
Dr. Thomas
W5
19/07/86
65356
Jack Spratt
Jaundice
Dr. Bradley
W2
09/01/73
Select the correct answers for the questions below...
How many records are displayed?
4
5
6
7
How many fields are displayed?
4
5
6
7
Which field is the primary key field?
WardID
PatientID
Name
Doctor
A new record of data is added to this file if...
A patient is moved to another ward
A patient changes to another doctor
A patient is discharged from hospital
A patient is admitted to the hospital
The data in an existing record may be changed if...
A new patient is admitted to hospital
A patient is moved to another ward
A patient has a surgical operation
A patient is visited by the doctor
WELL DONE!!
Back