$(8$pts$)$ Consider a table with attributes $A_{,}{B}_{,}{C}_{,}D,E,F,G,$ and $H,$ where the primary key is $($A$,$B$,$C$).$ Suppose that $(B,C)E$; that $CF,$ ; that $FG$; and that $HD.$ a$.$

a$.(4$pts$)$ Identify all partial and transitive dependencies.

b$.(2$pts$)$ Normalize the table to $2$NF by addressing all partial dependencies.

c$.(2$pts$)$ Normalize the database to $3$NF by addressing all transitive dependencies in your answer

to $3$c