Modify this table in 3 stages to make it a proper set of DB tables using...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these marketing questions
-
Please write an summary according to the article. Please don't copy from others and write full view of article in the summary. Value creation. Wealth creation. These are really powerful words. Maybe...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
1. Calculate the density of O2, in g/L, at STP. 1.62 g/L b. 0,714 g/L 1.43 g/L. d. 1.14 g/L e. 0.810 g/L a. .
-
The Johnsons recently decided to invest in municipal bonds because their marginal tax rate is 40 percent. The return on municipal bonds is currently 3.5 percent and the return on similar taxable...
-
The demand for rutabagas is still Q = 2,000 300P and the supply is still Q = 100 + 100P, as in Question 2. Governor Sloop decides that instead of imposing the $2 sales tax described in Question 2,...
-
Identifying Weaknesses and Inefficiencies in n Purchasing System Madeline Jones, the Lecimore Company's purchasing department manager, has established new policies and procedures to guide the...
-
You currently pay $10,000 per year in rent to a landlord for a $100,000 house, which you are considering purchasing. You can qualify for a loan of $80,000 at 9% if you put $20,000 down on the house....
-
A child's toy has a solid plastic sphere of radius 20cm that can be rotated about its center. Child A applies a force of 30N tangent to the edge of the sphere to cause it to rotate counter clockwise....
-
Onslow Company purchased a used machine for $240,000 cash on January 2. On January 3, Onslow paid $10,000 to wire electricity to the machine. Onslow paid an additional $2,000 on January 4 to secure...
-
Annie and Newton are 19-year-old sophomores at Open House University, a public state institution. They have been dating for eight months and both live in the residence halls. Newton suffers from...
-
Identify a recent verbal communication you were involved in, perhaps one that you felt uncomfortable about, and write it down in the space provided (we have given an example). Communication I was...
-
The Problem: I was working with a highly successful seniors' organization that seemed to be about to use the power it had built up within the community to block a much-needed centre for local...
-
1. How should I reply constructively, In order to assess the law firms my company has worked with over the last year, I would begin by engaging a cross-discipline committee comprised of legal,...
-
Read the case opinions one at a time - after reading a single opinion draft a rule statement for each case. After you have four separate rules statements, consider how you can synthesize the four...
-
One evening you are standing outside by a palm tree. The palm tree is 40 feet tall. Your are 2 meters tall. What is your scale compared to the palm tree? Above the palm tree is the moon. You note...
-
QUESTION 2 The CEO of Farisha Hijab Sdn Bhd insisted on further investigation to be carried out that he also required Mr Muaz to conduct the analysis of variance for the material and labour of the...
-
A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account: CHECKING: Acct No, Date Opened, Balance, Service Charge SAVINGS: Acct No, Date...
-
Describe the core idea underlying in-memory database management systems.
-
Are there procedures and processes that are common to the use of SDLC, prototyping, and agile methodologies? Explain any that you can identify and then indicate why the methodologies are considered...
-
Which of the following is usually observed in a complex computer system? A. The underlying technology has a high rate of change. B. It is easy to write a succinct description of the behavior of the...
-
If one created a graph of personal friendships, one would have a hierarchy. True or false?
-
Ben Bitdiddle has accepted a job with the telephone company and has been asked to implement call forwarding. He has been pondering what to do if someone forwards calls to some number and then the...
Study smarter with the SolutionInn App