Figure 13.18 [1] Examine the Patient Medication Form for the Wellmeadows Hospital. (a) Identify all the candidate keys. (b) Decide a primary key. (c) Identify (all) the functional dependencies represented by the attributes shown in the form in Figure 13.18. State any assumptions you make about the data and the attributes shown in this form. (d) Describe and illustrate the process of normalizing the attributes shown above Figure to produce a set of well-designed 3NF relations (1st normal form, 2nd normal form, and 3rd normal form). 1st Normal Form: Definition: Normal For: 2nd Normal Form: Definition: Normal Form: 3rd Normal Form: Definition: Normal Form [client/Property view] Table clientNo fName lName propertyNo viewDate comment CR56 Aline Stewart PA14 5/24/2001 too small CR56 Aline Stewart PG36 4/28/2001 street 16 Holhead 2 Manor Rd CR56 Aline Stewart PG4 5/26/2001 6 Lawrence St Glasgow CR62 CR74 Mary Mike Tiregear PA14 Richie PG4 5/14/2001 no dining room 16 Holhead Aberdeen 4/21/2001 6 Lawrence St Glasgow CR76 John Kay 4/20/2001 too remote PG4 6 Lawrence St Glasgow Street and city represent a property’s address. [2] Please find out the primary key from above table. [3] Please identify all the functional dependencies in minimum set. [4] Please convert above table to the second normal form. [5] Please convert [4] to the third normal form city Aberdeen Glasgow