$(8$pts$)$ Consider a table named $x,$ with attributes $A_{,}{B}_{,}C,D,$ and $E,$ where the primary key is $.$

Suppose that $AC,$ and that $DE.$

a$.(2$pts$)$ Identify the partial dependency and the transitive dependency.

b$.(2$pts$)$ Normalize the table to $2NF$ by addressing the partial dependency. Call the new table $Y.$

c$.(2$pts$)$ Normalize the database to $3NF$ by addressing the transitive dependency in your answer to Question $2$c$.$ Call the new table Z$.$

d$.(2$pts$)$ Identify all foreign keys in your answer to $2$c$.$ For each FK$,$ indicate the name of the FK$,$ the table that contains the FK$,$ and the table that the FK refers to$.$