What is normalization? - 5 points 2. When is a table in 1NF? - 5 points 3. When is a table in 2NF? - 5 points 4. When is a table in 3NF? - 5 points 5. When is a table in BCNF? - 5 points 6. Given the dependency diagram shown Figure below answer Items 6a, 6b, and 6c. 10 points Figure Q6.6Dependency Diagram for Question 6 a) Identify and discuss each of the indicated dependencies. b) Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table. c) Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table. 7. The dependency diagram in Figure Q6.7 indicates that authors are paid royalties for each book they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book. 10 points Figure Q6.7Book Royalty Dependency Diagram CS457 : Data Modelling and Implementa?on Technique pg. 2 a) Based on the dependency diagram, create a database whose tables are at least in 2NF, showing the dependency diagram for each table. b) Create a database whose tables are at least in 3NF, showing the dependency diagram for each table. 8. What is a partial dependency? With what normal form is it associated? 5 points 9. What three data anomalies are likely to be the result of data redundancy? How can such anomalies be eliminated? 10 points 10. Define and discuss the concept of transitive dependency. 5 points 11. Why is a table whose primary key consists of a single attribute automatically in 2NF when it is in 1NF? 5 points 12. How would you describe a condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?