Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 7 (1 point) Given the following decomposition in which a larger table EMP_PROJ is decomposed into two smaller tables EMP_PROJ1 and EMP_LOC which ONE
Question 7 (1 point) Given the following decomposition in which a larger table EMP_PROJ is decomposed into two smaller tables EMP_PROJ1 and EMP_LOC which ONE of the following statements is TRUE about why the data would be corrupted (not represent the original data)? EMP PROJ SSN 123456789 123456789 666884444 453453453 453453453 PNUMBER HOURS ENAME 32.5 Smith, John 2 7.5 Smith, John 3 40 Narayan, Ramesh 1 20 English, Joyce 2 20 English, Joyce PNAME PLOCATION X Bellaire Y Sugarland Z Houston X Bellaire Y Sugarland EMP PROJ1 SSN 123456789 123456789 666884444 453453453 453453453 PNUMBER HOURS PNAME PLOCATION 32.5 Bellaire 2 7.5 Y Sugarland 3 40 z Houston 1 20 Bellaire 2 20 Y Sugarland NWN EMPLOC ENAME PLOCATION Smith, John Bellaire Smith, John Sugarland Narayan, Ramesh Houston English, Joyce Bellaire English, Joyce Sugarland Because the tables EMP_PROJ1 and EMP_LOC do not have the same key. Because there are columns of the original table that don't appear in the new decomposed tables. Because ENAME does not appear in both of the tables EMP_PROJ1 and EMP_LOC. Because tables EMP_PROJ and EMP_PROJ1 have the same key. Because PLOCATION is not a foreign key in the decomposed tables
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started