Examine the Patient Medication Form for the Well meadows Hospital case study shown in Figure 14.18.

(a) Identify the functional dependencies represented by the data shown in the form in Figure 14.18.
(b) Describe and illustrate the process of normalizing the data shown in Figure 14.18 to First (1NF), Second (2NF), and Third (3NF).
(c) Identify the primary, alternate, and foreign keys in your 3NF relations.

Transcribed Image Text:

Wellmeadows Hospital Patient Medication Form Patient Number: P10034 Full Name: Robert MacDonald Ward Number: Ward 11 Bed Number: 84 Ward Name: Orthopaedic Drug Name Description Dosage Method of Units per Start Date Finish Date Number 022 Morphine Pai Killer OmgimOral 04TetracycleneAntibiotic O5ma/m 1022 Morphine Pa Kile 0mgim Oral Admin Day 50 10 10 24/03/13 24104/14 24103/13 170413 25/04/14 0205/15