Referring to the table below: 1. Depict full key functional dependencies, partial functional dependencies (if any), and transitive functional dependencies (if any) in the MOVIE ACTORS Table. 2. Show the result of normalizing the MOVIE ACTORS Table to 2NF. 3. Show the result of normalizing the MOVIE ACTORS Table in 3NF.

EA.12 Consider the following relation with sample data. MOVIE ACTORS TABLE MovielD MovieName ActoriD ActorName ActorAssistantID ActorAssistantName ActorMovieSalary M100 Silent Code M100 Silent Code M100 Silent Code A33 Esmeralda Po AA02 M100 Silent Code A44 C.C. Rooney AA02 M200 Winter Promises A11 Paloma Luna AA03 M200 Winter Promises A33 C.C. M200 Winter Promises A55 Max SmithAA02 A11 Paloma Luna AA01 Logan Jones AA01 Julie J. Julie J Bob B.$ Bob B Lisa L Julie J. Bob B. $1,200,000 $1,300,000 $1.200,001 $500,000 $1,000,000 $900,000 $300,000 Rooney AAO1 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. 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. Each movie has multiple actors appearing in it. Each actor can appear in multiple movies