Case $3$ Normalization $(28$ Points$)$:

The following table is a sample of movies in a movie dataset.

$\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline FilmID & FilmTite & $\backslash$begin$\{$tabular$\}\{$l$\}$

Divect $\backslash \backslash$

orID

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Director $\backslash \backslash$

Name

$\backslash$end$\{$tabular$\}$ & actorID & actorName $\backslash \backslash$

$\backslash$hline F$1100$ & CIS & D$101$ & Tom Alen & A$1020$ & Shila Toner $\backslash \backslash$

$\backslash$hline F$1100$ & CIS & D$101$ & Tom Alen & A$1222$ & Pet Watt $\backslash \backslash$

$\backslash$hline F$1109$ & allGradeA & D$076$ & King Kong & A$1567$ & Steve Mike $\backslash \backslash$

$\backslash$hline F$1109$ & allGradeA & D$076$ & King Kong & A$1222$ & Pet Watt $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Assuming:

$-$ each movie only have one director

Tasks:

a$.$ Please choose a key

b$.$ Write the function dependencies

c$.$ Please normalize to $3$NF

Note: please provide detailed steps