Illustrate the process of normalizing the data shown in the figure below by a) list the business rules (5 points). For example: one patient may receive many drugs , b) show fields in 1NF (5 points), b) show fields in 2NF (5 points), and show fields in 3NF (5 points). Consider all the fields shown on the form.

Welmeadows Hospital Patient Medication Form Patient Number: P10034 Ward Number: Ward 11 Full Name: Robert MacDonald Bed Number: 84 Ward Name: Orthopaedic LA Name Drug Number Description Dosage Method of Units per Start Date Finish Date Admin Day Oral 24/04/14 10223 10334 10223 Morphine Pain Killer Tetracyclone Antibiotic Morphine Painkiller 1mg/ml 0.5mg/ml 10mg/ml 50 10 24/03/13 24/03/13 25/04/14 17/04/13 02/05/15 Oral 10