The table shown below displays the details of the roles played by actors/actresses in films.
filmNo fTitle
dirNo director
actorNo aName
role
timeOnScreen
FTOO
Happy Days DIOI
Jim Alan
A1020
Sheila Toner
Jean Sinson
15.445
DIOI
Jim Alan
Al222
Peter Watt
Tom Kinder
25.38
DIOI
Jim Alan
A1020
Sheila Toner
Silvia Simpson
22.56
FT109
Snake Bite
D076
Sue Ramsay
1567
Steven McDonald
Tim Rosey
19.56
D076
Suc Ramsay
A[222
Peter Watt
Archic Bold
0.44
a) Analyze why the table shown above is not in first normal form (1NF)
b) The table shown above is susceptible to update anomalies. Provide examples of how insertion, deletion, and modification anomalies could occur on this table.
c) Convert it into 1NF, 2NF, and 3NF.