Database research
Grade 9 Homework: Due Week ending 24/02/05
Answer all of the following, you may need
to do some research (try wikipedia, how stuff works, hyperdictionery etc.
For database design, provide written definitions and
explain why the following are important:
Data integrity, Validation, Atomicity, Date stamping,
Redundancy
As far as you can, define normalisation (what is first normal form, second normal form and third normal form).
Analyse the following
In a doctor's surgery a database is being
installed to store appointment details, medical records and stock control in
the drug dispensary.
The Doctors
The receptionist - appointment arrangers
The dispensing chemists
The database will contain at least the following information fields:
|
Patient details |
Name |
Address |
Photo |
Phone No. |
Social security No. |
|
Medical details |
Date of consultation |
Complaint or ailment |
Action taken |
Drugs prescribed |
Referral to hospital |
|
|
Allergies |
Long-term illnesses |
Alcohol intake |
Tobacco usage |
Follow-up |
|
|
operations |
Blood pressure |
Resting pulse |
Lifestyle information |
Addiction |
|
Dispensary details |
Drug name |
Current stock |
Stock remaining |
Stock reminders |
|
Which information fields should be accessible to:
-
Doctors
Receptionist/ appointment arranger
Dispensing Chemist
Justify your answers with a brief explanation