For the following relation, define two subsets X and Y of attributtes such that Y is...

 

Transcribed Image Text:

For the following relation, define two subsets X and Y of attributtes such that Y is NOT functionally dependent on X. Explain why. FIRST NAME LAST_NAME EMAIL PHONE NUMBER HIRE_DATE JOB_ID Steven Neena wwwwww Lex Neena wwwwww Lex Alexander Bruce Neena wwwwww King Kochhar De Haan www Kochhar De Haan www Hunold wwwwww Ernst Kochhar SKING NKOCHHAR LDEHAAN NKOCHHAR LDEHAAN AHUNOLD BERNST 515.123.4567 N..KatGMAIL.COM 515.123.4568 515.123.4569 17-06-2003 00:00 AD_PRES 515.123.4568 515.123.4569 590.423.4568 590.423.4567 21-09-2005 00:00 AD_VP 13-01-2001 00:00 AD_VP 21-09-2005 00:00 AD_VP 13-01-2001 00:00 AD_VP 515.123.4567 03-01-2006 00:00 IT_PROG 21-05-2007 00:00 IT_PROG 27-01-1990 00:00 AD PRESS For the following relation, define two subsets X and Y of attributtes such that Y is NOT functionally dependent on X. Explain why. FIRST NAME LAST_NAME EMAIL PHONE NUMBER HIRE_DATE JOB_ID Steven Neena wwwwww Lex Neena wwwwww Lex Alexander Bruce Neena wwwwww King Kochhar De Haan www Kochhar De Haan www Hunold wwwwww Ernst Kochhar SKING NKOCHHAR LDEHAAN NKOCHHAR LDEHAAN AHUNOLD BERNST 515.123.4567 N..KatGMAIL.COM 515.123.4568 515.123.4569 17-06-2003 00:00 AD_PRES 515.123.4568 515.123.4569 590.423.4568 590.423.4567 21-09-2005 00:00 AD_VP 13-01-2001 00:00 AD_VP 21-09-2005 00:00 AD_VP 13-01-2001 00:00 AD_VP 515.123.4567 03-01-2006 00:00 IT_PROG 21-05-2007 00:00 IT_PROG 27-01-1990 00:00 AD PRESS For the following relation, define two subsets X and Y of attributtes such that Y is NOT functionally dependent on X. Explain why. FIRST NAME LAST_NAME EMAIL PHONE NUMBER HIRE_DATE JOB_ID Steven Neena wwwwww Lex Neena wwwwww Lex Alexander Bruce Neena wwwwww King Kochhar De Haan www Kochhar De Haan www Hunold wwwwww Ernst Kochhar SKING NKOCHHAR LDEHAAN NKOCHHAR LDEHAAN AHUNOLD BERNST 515.123.4567 N..KatGMAIL.COM 515.123.4568 515.123.4569 17-06-2003 00:00 AD_PRES 515.123.4568 515.123.4569 590.423.4568 590.423.4567 21-09-2005 00:00 AD_VP 13-01-2001 00:00 AD_VP 21-09-2005 00:00 AD_VP 13-01-2001 00:00 AD_VP 515.123.4567 03-01-2006 00:00 IT_PROG 21-05-2007 00:00 IT_PROG 27-01-1990 00:00 AD PRESS For the following relation, define two subsets X and Y of attributtes such that Y is NOT functionally dependent on X. Explain why. FIRST NAME LAST_NAME EMAIL PHONE NUMBER HIRE_DATE JOB_ID Steven Neena wwwwww Lex Neena wwwwww Lex Alexander Bruce Neena wwwwww King Kochhar De Haan www Kochhar De Haan www Hunold wwwwww Ernst Kochhar SKING NKOCHHAR LDEHAAN NKOCHHAR LDEHAAN AHUNOLD BERNST 515.123.4567 N..KatGMAIL.COM 515.123.4568 515.123.4569 17-06-2003 00:00 AD_PRES 515.123.4568 515.123.4569 590.423.4568 590.423.4567 21-09-2005 00:00 AD_VP 13-01-2001 00:00 AD_VP 21-09-2005 00:00 AD_VP 13-01-2001 00:00 AD_VP 515.123.4567 03-01-2006 00:00 IT_PROG 21-05-2007 00:00 IT_PROG 27-01-1990 00:00 AD PRESS