Examine the Patient Medication Form for the Wellmeadows Hospital case study shown

(a) Identify the functional dependencies represented by the attributes shown in the form in Figure 14.18. State any assumptions that you make about the data and the attributes shown in this form.
(b) Describe and illustrate the process of normalizing the attributes shown in Figure 14.18 to produce a set of well-designed 3NF relations.
(c) Identify the primary, alternate, and foreign keys in your 3NF relations.

Answer: (a) Identify the functional dependencies represented by the data shown in the form
patientNo ??fullName
wardNo ??wardName
wardName ??wardNo
drugNo ? name, description, dosage, methodOfAdmin
patientNo, drugNo, startDate ? unitsPerDay, finishDate
The functional dependencies for bedNo are unclear. If bedNo was a unique number for the
entire hospital, then could say that bedNo ??wardNo. However, from further examination of
the requirements specification, we can observe that bedNo is to do with the allocation of
patients on the waiting list to beds.