Case 3 Normalization (25 Points): The following table is a sample of movies in a movie dataset. FilmID Film Title Director actorID actorName Role Direct orID Name F1100 CIS D101 Tom Alen A1020 Shila Toner Jack Simson F1100 CIS D101 Tom Alen A1222 Pet Watt Kean Kinder F1100 CIS D101 Tom Alen A1020 Shila Toner Saliva Simpson F1109 allGradeA D076 King Kong A1567 Steve Mike Tome Rosey F1109 allGradeA D076 King Kong A1222 Pet Watt David Bold Given the primary key (FilmID, actorID, Role), assuming each movie only has one director a. Write the function dependencies b. Normalize to 3NF Note: Please provide detailed steps Case 3 Normalization (25 Points): The following table is a sample of movies in a movie dataset. FilmID Film Title Director actorID actorName Role Direct orID Name F1100 CIS D101 Tom Alen A1020 Shila Toner Jack Simson F1100 CIS D101 Tom Alen A1222 Pet Watt Kean Kinder F1100 CIS D101 Tom Alen A1020 Shila Toner Saliva Simpson F1109 allGradeA D076 King Kong A1567 Steve Mike Tome Rosey F1109 allGradeA D076 King Kong A1222 Pet Watt David Bold Given the primary key (FilmID, actorID, Role), assuming each movie only has one director a. Write the function dependencies b. Normalize to 3NF Note: Please provide detailed steps