Referring to the table below: 1. Depict full key functional dependencies, partia

Question

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.

Explanation / Answer

1.

Full Key Functional Dependencies :

MovieID,ActorID -> ActorMovieSalary

Partial Functional Dependencies :

MovieID -> MovieName

ActorID -> ActorName

Transitive Functional Dependencies :

ActorAssistantID -> ActorAssistantName

2. 2NF tables

MOVIE

ACTOR

MOVIEACTOR

3. 3NF

MOVIE

ACTOR

MOVIEACTOR

ACTORASSISTANT

Do ask if any doubt. Please upvote.

MovieID MovieName M100 Silent Code M200 Winter Promises

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.