Question: 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!