The table shown below displays the details of the roles played by actors/actresses in films. dirNo...

Transcribed Image Text:

The table shown below displays the details of the roles played by actors/actresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean Simson Tom Kinder Silvia Simpson Tim Rosey Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 i. Describe why the table shown above is not in first normal form (INF). ii. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table, if necessary. iii. Using the functional dependencies identified in part (ii), illustrate the process of normalisation by converting the table shown above to third normal form (3NF). Identify the primary and foreign keys in your 3NF. The table shown below displays the details of the roles played by actors/actresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean Simson Tom Kinder Silvia Simpson Tim Rosey Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 i. Describe why the table shown above is not in first normal form (INF). ii. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table, if necessary. iii. Using the functional dependencies identified in part (ii), illustrate the process of normalisation by converting the table shown above to third normal form (3NF). Identify the primary and foreign keys in your 3NF. The table shown below displays the details of the roles played by actors/actresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean Simson Tom Kinder Silvia Simpson Tim Rosey Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 i. Describe why the table shown above is not in first normal form (INF). ii. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table, if necessary. iii. Using the functional dependencies identified in part (ii), illustrate the process of normalisation by converting the table shown above to third normal form (3NF). Identify the primary and foreign keys in your 3NF. The table shown below displays the details of the roles played by actors/actresses in films. dirNo Happy Days D101 D101 D101 D076 D076 Sue Ramsay A1222 film No fTitle F1100 F1109 Snake Bite actorNo aName director Jim Alan Jim Alan A1020 Sheila Toner A1222 Peter Watt A1020 Sue Ramsay A1567 Jim Alan Sheila Toner Steven McDonald Peter Watt role Jean Simson Tom Kinder Silvia Simpson Tim Rosey Archie Bold timeOnScreen 15.45 25.38 22.56 19.56 10.44 i. Describe why the table shown above is not in first normal form (INF). ii. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table, if necessary. iii. Using the functional dependencies identified in part (ii), illustrate the process of normalisation by converting the table shown above to third normal form (3NF). Identify the primary and foreign keys in your 3NF.

Answer rating: 100% (QA)

Based on the provided table the given table is not in first normal form 1NF due to the repetition of actor information within each film This repetition leads to data redundancy and potential inconsist... View the full answer