Normalize following table up to BCNF$.$

Examine the Patient Medication Form for the Wellmeadows Hospital case study

Note: Method of admin can be decided by the drug number. Dosage is a unit

measurement of the drug. The daily dosage of the drug can be calculated by Dosage times

Units per day.

$($a$)$ Identify the functional dependencies represented by the data shown in the

form above.

$($b$)$ Describe and illustrate the process of normalizing the data shown in Figure

$13\mathrm{.}25$ to first $(1$NF$),$ second $(2$NF$),$ third $(3$NF$),$ and BCNF$.$

$($c$)$ Identify the primary, alternate, and foreign keys in your relations.