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

(a) Describe why the table shown below 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) Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table (if necessary).
(d) Using the functional dependencies identified in part (c), describe and illustrate the process of normalization by converting the table shown in Figure 1 to Boyce-Codd Normal Form (BCNF). Identify the primary and foreign keys in your BCNF relations.
(e) Sketch an Entity-Relationship model for the data shown in table above.

Question

The table shown below displays the details of the roles played by actors/actresses in films. 
 
 (a) Describe why the table shown below 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) Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table (if necessary). 
(d) Using the functional dependencies identified in part (c), describe and illustrate the process of normalization by converting the table shown in Figure 1 to Boyce-Codd Normal Form (BCNF). Identify the primary and foreign keys in your BCNF relations.
(e) Sketch an Entity-Relationship model for the data shown in table above.

Quizplus · Accepted Answer

The Answer of The table shown below displays the details of the roles played by actors/actresses in films. 
 
 (a) Describe why the table shown below 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) Identify the functional dependencies represented by the table shown above. State any assumptions you make about the data shown in this table (if necessary). 
(d) Using the functional dependencies identified in part (c), describe and illustrate the process of normalization by converting the table shown in Figure 1 to Boyce-Codd Normal Form (BCNF). Identify the primary and foreign keys in your BCNF relations.
(e) Sketch an Entity-Relationship model for the data shown in table above.

The Table Shown Below Displays the Details of the Roles