Which of the following outputs would be produced when this SELECT is executed? Explain. (Note: data...

  

Transcribed Image Text:

Which of the following outputs would be produced when this SELECT is executed? Explain. (Note: data shown below in question #2!) SQL SELECT donor.idno, name, yrgoal, donation.driveno, contamt, drivename 2 FROM donation, donor, drive 3 WHERE donation.idno = donor.idnc and donation.driveno = drive.driveno; Output A: IDNO NAME YRGOAL DRI CONTAMT DRIVENAME 11111 Stephen Daniels 500 100 25 Animal Home 12121 Jennifer Ames 400 200 40 Animal Home 23456 Susan Ash 100 100 20 Animal Home 33333 Nancy Taylor 22222 Carl Hersey 50 300 100 10 Animal Home 10 Animal Home 50 Animal Home 35 Animal Home 12121 Jennifer Ames 400 100 11111 Stephen Daniels 23456 Susan Ash 500 200 100 300 10 Animal Home Output B: IDNO NAME YRGOAL DRI CONTAMT DRIVENAME 23456 Susan Ash 100 100 20 Kids Shelter 23456 Susan Ash 100 100 20 Animal Home 23456 Susan Ash 100 100 20 Health Aid 23456 Susan Ash 33333 Nancy Taylor 33333 Nancy Taylor 33333 Nancy Taylor 33333 Nancy Taylor 23456 Susan Ash 23456 Susan Ash 23456 Susan Ash 23456 Susan Ash 100 100 20 Half Way 10 Kids Shelter 50 300 50 300 10 Animal Home 50 300 50 300 10 Health Aid 10 Half Way 10 Kids Shelter 100 300 100 300 10 Animal Home 10 Health Aid 10 Half Way 100 300 100 300 Output C: IDNO NAME YRGOAL DRI CONTAMT DRIVENAME 500 100 25 Kids Shelter 20 Kids Shelter 10 Kids Shelter 50 Kids Shelter 11111 Stephen Daniels 23456 Susan Ash 100 100 22222 Carl Hersey 12121 Jennifer Ames 100 400 100 400 200 40 Animal Home 35 Animal Home 10 Health Aid 12121 Jennifer Ames 11111 Stephen Daniels 33333 Nancy Taylor 500 200 50 300 23456 Susan Ash 100 300 10 Health Aid Which of the following outputs would be produced when this SELECT is executed? Explain. (Note: data shown below in question #2!) SQL SELECT donor.idno, name, yrgoal, donation.driveno, contamt, drivename 2 FROM donation, donor, drive 3 WHERE donation.idno = donor.idnc and donation.driveno = drive.driveno; Output A: IDNO NAME YRGOAL DRI CONTAMT DRIVENAME 11111 Stephen Daniels 500 100 25 Animal Home 12121 Jennifer Ames 400 200 40 Animal Home 23456 Susan Ash 100 100 20 Animal Home 33333 Nancy Taylor 22222 Carl Hersey 50 300 100 10 Animal Home 10 Animal Home 50 Animal Home 35 Animal Home 12121 Jennifer Ames 400 100 11111 Stephen Daniels 23456 Susan Ash 500 200 100 300 10 Animal Home Output B: IDNO NAME YRGOAL DRI CONTAMT DRIVENAME 23456 Susan Ash 100 100 20 Kids Shelter 23456 Susan Ash 100 100 20 Animal Home 23456 Susan Ash 100 100 20 Health Aid 23456 Susan Ash 33333 Nancy Taylor 33333 Nancy Taylor 33333 Nancy Taylor 33333 Nancy Taylor 23456 Susan Ash 23456 Susan Ash 23456 Susan Ash 23456 Susan Ash 100 100 20 Half Way 10 Kids Shelter 50 300 50 300 10 Animal Home 50 300 50 300 10 Health Aid 10 Half Way 10 Kids Shelter 100 300 100 300 10 Animal Home 10 Health Aid 10 Half Way 100 300 100 300 Output C: IDNO NAME YRGOAL DRI CONTAMT DRIVENAME 500 100 25 Kids Shelter 20 Kids Shelter 10 Kids Shelter 50 Kids Shelter 11111 Stephen Daniels 23456 Susan Ash 100 100 22222 Carl Hersey 12121 Jennifer Ames 100 400 100 400 200 40 Animal Home 35 Animal Home 10 Health Aid 12121 Jennifer Ames 11111 Stephen Daniels 33333 Nancy Taylor 500 200 50 300 23456 Susan Ash 100 300 10 Health Aid

Answer rating: 100% (QA)

When this S... View the full answer