Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

More Books

Students also viewed these Databases questions

Question

LO6 Describe how to choose among the recruitment sources.

Answered: 1 week ago