The fields in the table CANDYJOBS are called P$($person$$s name$),$ A$($ age$),$ O $($Occupation$),$ CN$($ name of a color$),$ CL$($ no of calories in that color$),$ and N $($ number of jellybeans of that color eaten by the person$).$ A person can eat more than one color jelly bean, and a color can be eaten by more than one person. Each person has one Occupation and each color has one value for the number of calories.

a$)$Show the complete set of functional dependencies.

b$)$what is the primary key of the table?

c$)$Is the table in $1-$NF$?$

d$)$Is the table in $2$NF$?$

e$)$Is the table in $3$NF$?$

f$)$Give two potential problems $($update anomalies$)$ that might result from leaving the table in its original form $($from part a$)$

g$)$Normalize the above table completely showing all steps.

h$)$Explain how your normalized tables solve the two problems mentioned in step f$.$