Question: That is my answer above but I need to submit it as a txt file. How would you type that answer out? E4.12 Consider the

That is my answer above but I need to submit it asa txt file. How would you type that answer out? E4.12 ConsiderThat is my answer above but I need to submit it as a txt file. How would you type that answer out?

E4.12 Consider the following relation with sample data MOVIE ACTORS TABLE MovieID MovieName M100Silent Code M 100 Silent Code | A22 M100 Silent Code M 100 | Silent Code M200 Winter Promises A11 M200Winter Promises A33 M200Winter Promises A55 ctorlD ActorName ActorAssistantiD ActorAssistantName ActorMovieSalary Paloma Luna AA01 | Logan Jones AA01 A33Esmeralda Po AA02 AA02 Paloma Luna AA03 C.C. Rooney AA01 Max Smith AA02 Julie J Julie J Bob B Bob B isa ulie J Bob B $1,200,000 $1,300,000 $1,200,001 $500,000 $1,000,000 $900,000 $300,000 A11 A44 C.C. Rooney .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 actors 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.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 MovieID MovieName M100Silent Code M 100 Silent Code | A22 M100 Silent Code M 100 | Silent Code M200 Winter Promises A11 M200Winter Promises A33 M200Winter Promises A55 ctorlD ActorName ActorAssistantiD ActorAssistantName ActorMovieSalary Paloma Luna AA01 | Logan Jones AA01 A33Esmeralda Po AA02 AA02 Paloma Luna AA03 C.C. Rooney AA01 Max Smith AA02 Julie J Julie J Bob B Bob B isa ulie J Bob B $1,200,000 $1,300,000 $1,200,001 $500,000 $1,000,000 $900,000 $300,000 A11 A44 C.C. Rooney .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 actors 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.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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!