[Solved]Question 19 4 Points Process Eliminating Transitive Dependency Following Occur Determinant Q37124108

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 Show transcribed image text 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

Expert Answer

---

Answer to Question 19 (4 points) In the process of eliminating a transitive dependency, which of the following will occur with the… . . .