3. The table1 shown below displays the details of the roles played by actors/actresses in films. Table1

a. Explain the purpose of data normalization and describe the main steps in the normalization process

b. Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table (if necessary).

c. Given the above information, i. Normalize the table 1 above to 1NF relation. Identify primary key in your 1NF relation. ii. Further normalize the 1NF relation to 2NF. Identify primary keys in your 2NF relations. iii. Convert the table structure developed in (ii) into a database that contains only 3NF relations. Identify the primary keys in your 3NF relations.

d. What conditions would make a 3NF relation violates Boyce-Codd Normal Form (BCNF)?

Documents - Word Sign in -0 File Home Insert Design Layout References MailingsReviewViewTell me what you want to do Share- Spacing : Before: 1-After: Align Group Rotate Line Numbers* _ Left: 0. 0 pt Position Wrap Bring Send Selection Tet-Forward-Backward- Margins Orientation Size Columns 8pt Pane Page Setup Paragraph Arrange filmila! tls | dito l director astarle alams role timeQuSeuseD F1100 Happy 0101 Jim Alan Days 0101 Jim Alan 0101Jim Alan A1020 A1222 A1020 Sheila Toner Peter Watt Sheila Toner Jean Simson Tom kinder Silvia Simpson 15.45 23.38 22.56 F1109 SnakeD076Sue Ramsay A1567 Steven McDonald Tim Rosey 19.56 10.44 Bite D076 Sue Ramsay A1222 Peter Watt Archie Bold Page 1 ot 1 59 wordsEnglish (United States 82% O Type here to search 6:55 PM 11/12/2017 2 Documents - Word Sign in -0 File Home Insert Design Layout References MailingsReviewViewTell me what you want to do Share- Spacing : Before: 1-After: Align Group Rotate Line Numbers* _ Left: 0. 0 pt Position Wrap Bring Send Selection Tet-Forward-Backward- Margins Orientation Size Columns 8pt Pane Page Setup Paragraph Arrange filmila! tls | dito l director astarle alams role timeQuSeuseD F1100 Happy 0101 Jim Alan Days 0101 Jim Alan 0101Jim Alan A1020 A1222 A1020 Sheila Toner Peter Watt Sheila Toner Jean Simson Tom kinder Silvia Simpson 15.45 23.38 22.56 F1109 SnakeD076Sue Ramsay A1567 Steven McDonald Tim Rosey 19.56 10.44 Bite D076 Sue Ramsay A1222 Peter Watt Archie Bold Page 1 ot 1 59 wordsEnglish (United States 82% O Type here to search 6:55 PM 11/12/2017 2