Database Management and Applications Exam 3 10. List all the functional dependencies present in the second...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Database Management and Applications Exam 3 10. List all the functional dependencies present in the second normal form compliant table(s). 11. List all the candidate keys. 12. Describe the steps you would take to bring the table(s) into third normal form compliance. Display the resulting third normal form compliant table or tables, identifying primary and foreign keys. Order ID Order Date 1006 Customer ID 10/24/10 2 Customer Name Product ID Product Product Desc. Price Quantity Ordered Value Dining 800.00 Furniture Table 5 Writers 325.00 2 Desk 4 Entertain 650.00 1 Center 1007 10/25/10 6 Furniture 11 Gallery 4 Drawer Dresser Entertain 650.00 Center 300.00 3 1. What errors prevent the table displayed above from being first normal form compliant? 2. List all the functional dependencies present in the table. 3. List all the candidate keys. 4. Describe the steps you would take to bring the table into first normal form compliance. Display the resulting first normal form compliant table or tables, identifying primary and foreign keys. 5. What error(s), if any, prevent the now first normal form compliant table or tables from being second normal form compliant? 6. List all the functional dependencies present in the first normal form compliant table(s). 7. List all the candidate keys. 8. Describe the steps you would take to bring the table(s) into second normal form compliance. Display the resulting second normal form compliant table or tables, identifying primary and foreign keys. 9. What error(s), if any, prevent the now second normal form compliant table or tables from being third normal form compliant? Whatsamatter U also has a number of students, of course. The table on the following page lists the information gathered for each student, plus 5 sample records. Some business rules that Whatsamatter U follows includes: Each student has a unique ID number A student has only a single advisor, but an advisor can have either zero or many students. Advisors are always faculty members (professors) A student can have only a single major but, of course, many students can have the same major A student can take a course more than once Using the above business rules and the data in Table 1 on the following page, do the following: 1. What errors prevent the table displayed above from being first normal form compliant? 2. List all the functional dependencies present in the table. 3. List all the candidate keys. Table 1 StudentID Name eMail Department N112233 Rocky Squirrel squirrel@wmu.edu GSCIS N121212 Bullwinkle Moose moose@wmu.edu Business Natasha Badenof Nat@Bad.net GSCIS N234432 Boris Badenof Boris@Bad.net GSICS Major Information Systems Accounting P456 Information Systems Computer Science AdvisorID Advisor CoursesTaken P123 John Data MMIS630 MMIS620 P123 Carl Numbers ACCT810 John Data MMIS630 MMIS630 MCIS610 P789 Rich Geek MCIS610 4. Describe the steps you would take to bring the table into first normal form compliance. Display the resulting first normal form compliant table or tables, identifying primary and foreign keys. 5. What error(s), if any, prevent the now first normal form compliant table or tables from being second normal form compliant? 6. List all the functional dependencies present in the first normal form compliant table(s). 7. List all the candidate keys. 8. Describe the steps you would take to bring the table(s) into second normal form compliance. Display the resulting second normal form compliant table or tables, identifying primary and foreign keys. 9. What error(s), if any, prevent the now second normal form compliant table or tables from being third normal form compliant? 10. List all the functional dependencies present in the second normal form compliant table(s). 11. List all the candidate keys. 12. Describe the steps you would take to bring the table(s) into third normal form compliance. Display the resulting third normal form compliant table or tables, identifying primary and foreign keys. Students N212121 End of document Database Management and Applications Exam 3 10. List all the functional dependencies present in the second normal form compliant table(s). 11. List all the candidate keys. 12. Describe the steps you would take to bring the table(s) into third normal form compliance. Display the resulting third normal form compliant table or tables, identifying primary and foreign keys. Order ID Order Date 1006 Customer ID 10/24/10 2 Customer Name Product ID Product Product Desc. Price Quantity Ordered Value Dining 800.00 Furniture Table 5 Writers 325.00 2 Desk 4 Entertain 650.00 1 Center 1007 10/25/10 6 Furniture 11 Gallery 4 Drawer Dresser Entertain 650.00 Center 300.00 3 1. What errors prevent the table displayed above from being first normal form compliant? 2. List all the functional dependencies present in the table. 3. List all the candidate keys. 4. Describe the steps you would take to bring the table into first normal form compliance. Display the resulting first normal form compliant table or tables, identifying primary and foreign keys. 5. What error(s), if any, prevent the now first normal form compliant table or tables from being second normal form compliant? 6. List all the functional dependencies present in the first normal form compliant table(s). 7. List all the candidate keys. 8. Describe the steps you would take to bring the table(s) into second normal form compliance. Display the resulting second normal form compliant table or tables, identifying primary and foreign keys. 9. What error(s), if any, prevent the now second normal form compliant table or tables from being third normal form compliant? Whatsamatter U also has a number of students, of course. The table on the following page lists the information gathered for each student, plus 5 sample records. Some business rules that Whatsamatter U follows includes: Each student has a unique ID number A student has only a single advisor, but an advisor can have either zero or many students. Advisors are always faculty members (professors) A student can have only a single major but, of course, many students can have the same major A student can take a course more than once Using the above business rules and the data in Table 1 on the following page, do the following: 1. What errors prevent the table displayed above from being first normal form compliant? 2. List all the functional dependencies present in the table. 3. List all the candidate keys. Table 1 StudentID Name eMail Department N112233 Rocky Squirrel squirrel@wmu.edu GSCIS N121212 Bullwinkle Moose moose@wmu.edu Business Natasha Badenof Nat@Bad.net GSCIS N234432 Boris Badenof Boris@Bad.net GSICS Major Information Systems Accounting P456 Information Systems Computer Science AdvisorID Advisor CoursesTaken P123 John Data MMIS630 MMIS620 P123 Carl Numbers ACCT810 John Data MMIS630 MMIS630 MCIS610 P789 Rich Geek MCIS610 4. Describe the steps you would take to bring the table into first normal form compliance. Display the resulting first normal form compliant table or tables, identifying primary and foreign keys. 5. What error(s), if any, prevent the now first normal form compliant table or tables from being second normal form compliant? 6. List all the functional dependencies present in the first normal form compliant table(s). 7. List all the candidate keys. 8. Describe the steps you would take to bring the table(s) into second normal form compliance. Display the resulting second normal form compliant table or tables, identifying primary and foreign keys. 9. What error(s), if any, prevent the now second normal form compliant table or tables from being third normal form compliant? 10. List all the functional dependencies present in the second normal form compliant table(s). 11. List all the candidate keys. 12. Describe the steps you would take to bring the table(s) into third normal form compliance. Display the resulting third normal form compliant table or tables, identifying primary and foreign keys. Students N212121 End of document
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Match the following ratios with the appropriate formula. Ratio or Rate Formula a. Income from operations Interest expense Acid-test Total liabilities Stockholders' equity Current b. Net income-...
-
Consider the modeling of aerobic fitness described in Problem 13.2.4 and the data set in DS 13.2.4. Suppose that a model is used with V02-max as the dependent variable and with heart rate at rest and...
-
"The accounting focus will shift from variance analysis to understanding the underlying cost structure of a product or process, highlighting significant cost trends, identifying cost reduction...
-
Which interest rate on a bond determines the amount of the semiannual interest payment? a. Market rate b. Effective rate c. Stated rate d. None of the above
-
You are managing a company that stocks and distributes hardware. The company employs two purchasing agents who receive combined salaries of $90,000. They process six thousand purchase requests per...
-
calculate the most current days of working capital (DWC) for Samsung and How does this company's ratio compare to those of its competitors?
-
Identify the main operator in the following propositions. 1. (A M ) (C E ) 2. (G P) (H W) 3. [P (S K)] 4. (K O) (R B) 5. (M B) [E (C I)] 6. [(P R) (E F)] 7. [(S L) M] (C N)...
-
Assume the following actual sales figures: Year 1 =3,302 Year 2= 2,800 Year 3 = 3,400 Year 4 = 3,522 Year 5 3,900 What are forecasted sales for year 6 using historical average sales growth rates?
-
What are the assumptions underlying the economic order quantity?
-
What are ordering costs? Provide some examples.
-
Japanese management and manufacturing techniques focus on principles like close supplier relationships, just-in-time deliveries and zero defects. Many western companies have implemented such...
-
Does the fact that selling is included as part of the promotional mix weaken or strengthen its role as a sub-element of marketing?
-
Let A and B be events with P (A) = 0.2 and P (B) = 0.9. Assume that A and B are independent. Find P (A and B).
-
Why does the Covid-19 pandemic significantly impact planning for capital expenditures (capital budgeting)? Describe the difficulties both for those impacted positively by the pandemic and those...
-
What exactly is a prima facie duty? How does an ethic of prima facie duties differ from monistic and absolutist ethical theories?
-
Describe the purpose of the SELECT command in relational algebra.
-
What is a visibility symbol in UML?
-
What is a sub query? When is a sub query executed?
-
Solve Prob. 8-48 using Castigliano's theorem. Data From Problem 8.48 = ABC 6.5(103) mm IBC 100(10) mm+ AAB = 18(10) mm IAR 400(10) mm+ DA = 3 m B -50 kN 1 m
-
Solve Prob. 8-40 using Castigliano's theorem. Data From Problem 8.40 2 k/ft 8 ft 8 ft B
-
Solve Prob. \(8-48\), including the effect of shear and axial strain energy. Data From Problem 8.48 = ABC 6.5(103) mm = = IBC 100(106) mm* AAB - 18(103) mm = TAR 400(10) mm A 3 m B -50 kN 1 m
Study smarter with the SolutionInn App