Modify this table in 3 stages to make it a proper set of DB tables using...

 

Transcribed Image Text:

Modify this table in 3 stages to make it a proper set of DB tables using the 3 rules of Database Design. Show all the intermediate stages. pub_phone book_no 1 1 2 2 author_no book_name 1 Psychology auname S. Yan authadr covr* pbno 1 1st St 1 1 pubna Wiley 222-3333 2 Psychology 1 3 Accounting Z. Gu S. Yan 2 2nd St 2 1 Wiley 222-3333 1 1st St 2 2 Sage Accounting S. Wu 3 3rd St 1 2 555-2222 Sage 555-2222 (Hint the final system has 4 tables) *covr cover order 20. In what field is the pbno (publisher no) in (1) NF2 and (2) NF3 A. (1) in the Book-author table and (2) publisher table B. (1) in the Author table and (2) book table C. (1) in the Book table and (2) book-author table D. (1) in the Book table and (2) publisher table 21. What is/are the key fields for NF1 A. Book_no B. Book_no and author_no C. Author_no D. Book_no and pbno 22. Is there a separate Publisher table in NF3? If so why? If not, why not? A. No, Because it does directly depend on book_no B. Yes, Because it does not directly depend on book_no C. Yes, Because it does directly depend on book_no and author_no D. THere is not enough information to answer this question 23. Why do we meed a separate table with author and book in both NF2 and NF3 A. So we will know who was the author for which book B. Just for extra information so we don't have to reference another table.. C. So we will know who published which book D. So we will know which author is first on the cover Modify this table in 3 stages to make it a proper set of DB tables using the 3 rules of Database Design. Show all the intermediate stages. pub_phone book_no 1 1 2 2 author_no book_name 1 Psychology auname S. Yan authadr covr* pbno 1 1st St 1 1 pubna Wiley 222-3333 2 Psychology 1 3 Accounting Z. Gu S. Yan 2 2nd St 2 1 Wiley 222-3333 1 1st St 2 2 Sage Accounting S. Wu 3 3rd St 1 2 555-2222 Sage 555-2222 (Hint the final system has 4 tables) *covr cover order 20. In what field is the pbno (publisher no) in (1) NF2 and (2) NF3 A. (1) in the Book-author table and (2) publisher table B. (1) in the Author table and (2) book table C. (1) in the Book table and (2) book-author table D. (1) in the Book table and (2) publisher table 21. What is/are the key fields for NF1 A. Book_no B. Book_no and author_no C. Author_no D. Book_no and pbno 22. Is there a separate Publisher table in NF3? If so why? If not, why not? A. No, Because it does directly depend on book_no B. Yes, Because it does not directly depend on book_no C. Yes, Because it does directly depend on book_no and author_no D. THere is not enough information to answer this question 23. Why do we meed a separate table with author and book in both NF2 and NF3 A. So we will know who was the author for which book B. Just for extra information so we don't have to reference another table.. C. So we will know who published which book D. So we will know which author is first on the cover