Note: For the first question the answer should be a diagram and tables.

Normalization Assignment ITEC 211 (10 marks) Q1) Examine the Patient Medication Form for the Wellmeadows Hospital case study shown in Figure Describe and illustrate the process of normalizing the data shown in Figure to first (1NF), second (2NF), and third (3NF). functional dependencies: staffNo, appointment Date, appointment Time patNo, patName staffNo dentistName patNo patName, surgeryNo staffiNo, appointment Date surgeryNo appointment Date, appointment Time, patNo staffiNo, dentistName functional dependencies represented by the data shown in the form in Figure Patient No Full Name Ward No Ward Name Drug No Name, Description, Dosage, Method of Admin Patient No, Drug No, Start Date Units per Day, Finish date