E4.12a Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the MOVIE ACTORS Table.

E4.12b Show the result of normalizing the MOVIE ACTORS Table to 2NF.

E4.12c Show the result of normalizing the MOVIE ACTORS Table to 3NF.

E4.12 Consider the following relation with sample data MOVIE ACTORS TABLE MovielD MovieName M100Silent Code M 100 Silent Code | A22 | Logan Jones AA01 M100Silent Code M100Silent Code M200Winter Promises A11 M200Winter Promises A33C M200 Winter Promises A55 Max SmithAA02 ActorlD ActorName ActorAssistantID ActorAssistantName ActorMovieSalary Julie J Julie J Bob B Bob B Lisa L Julie J Bob B Paloma Luna AA01 $1,200,000 $1,300,000 $1,200,001 $500,000 $1,000,000 $900,000 $300,000 A11 A33Esmeralda Po AA02 A44 C.C. Rooney AA02 Paloma Luna AA03 C.C. Rooney AA01 .The MOVIE ACTORS Table captures the data about actors appearing in movies. Each movie has a unique Movie ID and a Movie Name. Each actor has a unique Actor ID and an Actor Name. Each actor 's assistant has a unique Actor Assistant ID and an Actor Assistant Name. Each movie has multiple actors appearing in it. Each actor can appear in multiple movies. For each movie engagement, an actor receives a salary for appearing in a movie Each movie hires multiple actor 's assistants Each actor in a movie is assigned one actor 's assistant. one actor's assistant can be assigned to multiple actors in the same movie. An actor s assistant can provide assistance to actor(s) in multiple movies. E4.12 Consider the following relation with sample data MOVIE ACTORS TABLE MovielD MovieName M100Silent Code M 100 Silent Code | A22 | Logan Jones AA01 M100Silent Code M100Silent Code M200Winter Promises A11 M200Winter Promises A33C M200 Winter Promises A55 Max SmithAA02 ActorlD ActorName ActorAssistantID ActorAssistantName ActorMovieSalary Julie J Julie J Bob B Bob B Lisa L Julie J Bob B Paloma Luna AA01 $1,200,000 $1,300,000 $1,200,001 $500,000 $1,000,000 $900,000 $300,000 A11 A33Esmeralda Po AA02 A44 C.C. Rooney AA02 Paloma Luna AA03 C.C. Rooney AA01 .The MOVIE ACTORS Table captures the data about actors appearing in movies. Each movie has a unique Movie ID and a Movie Name. Each actor has a unique Actor ID and an Actor Name. Each actor 's assistant has a unique Actor Assistant ID and an Actor Assistant Name. Each movie has multiple actors appearing in it. Each actor can appear in multiple movies. For each movie engagement, an actor receives a salary for appearing in a movie Each movie hires multiple actor 's assistants Each actor in a movie is assigned one actor 's assistant. one actor's assistant can be assigned to multiple actors in the same movie. An actor s assistant can provide assistance to actor(s) in multiple movies