Question

Question 19 (4 points) In the process of eliminating a transitive dependency, which of the following will occur with the determinant (the non-key attribute that is determining another non-key attribute)? a) the determinant will become the foreign key on a new table b) the determinant will become the primary key of its own new table c) the determinant will become the foreign key on an existing table d) none of the above Question 20 (5 points Consider the following dependency diagram: ISBN BookTitle Author Num LastNamePublisher Royalty Edition Which of the following statements is true? a) ISBN determines BookTitle and Publisher. This is a transitive dependency b) BookTitle determines Publisher. This is a transitive dependency. c) Publisher determines Royalty. This is a transitive dependency d) ISBN and AuthorNum, combined, determine only BookTitle. This is a partial dependency Question 21 (4 points) From a structural point of view, 2NF is better than.__. 1) 1NF о 213NF 3) 4NF 4) BCNF

Answer 1

21. Option (1)

1 NF determines about the atomic values

A Structure is called 2 NF when it is 1 NF and non-key attribute are functional dependency so 2 NF is better than 1 NF

19. Option (2)

The Determinant will become primary key of it's own new table.

20. Option (b)

Book determines Publisher. This is a Transitive Dependency

As Book Determines Publisher and Publisher determines Book so there is a Transitive Dependency