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 data set in DS 13.6.1. (a) Plot the response variable y against the input variable x and confirm that the quadratic model y = 0 + 1x + 2x2 appears to be appropriate. (b) Write out the...
-
John Jones, a new university graduate, has just been appointed as an assistant accountant in the small business division of a public accounting practice. One of Johns first tasks is to verify the...
-
Gold-on-gold nuclear collisions at the Relativistic Heavy Ion Collider (RHIC) at the Brookhaven National Laboratory create a quark-gluon plasma with an energy density of about \(4 \mathrm{GeV} /...
-
Kansas Company uses a standard cost accounting system. In 2014, the company produced 28,000 units. Each unit took several pounds of direct materials and 1.6 standard hours of direct labor at a...
-
A polar exploration team based near the south pole is faced with an emergency in which a very important housing and supplies module must be lifted by a special 1 crane, swung across a deep glacial...
-
Summarizes current non-GAAP reporting practices in the industry; TOYOTA VS HONDA Include tables or other appropriate visualizations that reflect information about your companies, including...
-
For the following project, the IRR and the Rate that maximizes the NPV are: Project A 0 -500 100 -8 1 28 100 38 100 48 100 100 58 6 7 8 9 100 100 100 100 10 -150
-
The intensity of the sound wave from a jet airplane as it is taking off is 108 W/m 2 at a distance of 4.00 m. A person is standing at a distance of 110 m from the runway. Assume that the sound wave...
-
How could the placement of a construction crane at an airport construction site adversely affect an ILS? Question options: 1) The crane could block the pilot's view of the runway environment 2) Noise...
-
Donna contacts you asking why she is not receiving the child tax credit for her 7 year old granddaughter. Donna is 63 years old and is the sole caretaker of her granddaughter. Income on this year's...
-
Apakah yang dimaksud dengan profesi Auditor ? Serta jelaskan fungsi dari profesi Eksternal Auditor, dalam hubungannya dengan pihak manajemen perusahaan maupun masyarakat.tantangan yang dihadapi oleh...
-
My portfolio keeps going up and down. I can buy stock, at the end of the day I find myself making losses with the new stalk. I've found the game to be challenging and sometimes I have to use guess...
-
Read the case study Wireless And Remote Connectivity Challenge_Sanford University and write detailed analytical paper on it.
-
Question 6.10 Current and deferred tax worksheets and tax entries From the hip Ltd?s statement of profit or loss for the year ended 30 June 2007 and extracts from its statements of financial position...
-
In a steam power plant, coal is burned at the rate of 50 lbm/min. The percentage of ash in the coal is 9% by mass. The combustion of coal takes place in a fluidized bed reactor and the ash in the...
-
2-Mercaptoethanol (C 2 H 6 OS) is produced by reacting ethylene oxide (C 2 H 4 O) with hydrogen sulfide (H 2 S) as per the following reaction equation. The reaction takes place in the presence of...
-
Chlorobenzene is produced by direct chlorination of benzene. However, a parallel reaction that produces dichlorobenzene hexachloride also occurs. The parallel reactions are shown here. The single...
Study smarter with the SolutionInn App