Question

Student Roster Student Email Class Days Time Instructor Phone Fred Flintstone ff@brc.edu Java PromeM 7.00PM P.R.O'Grammer 206-880-3232 Wilma Flintstone wf@brc.edu Java Promo M 7:00PM P.R. OʻGrammer 206-880-3232 Wlima Flintstone wf@brc.edu Database T 7.00PM S.O.Elle 206-448-9876 Barney Rubble br@brc.edu Database T 7:00PM S.Q.Elle 206-448-9876 BamBam Rubble br@bre.edu Hacking M 5:00PM S.N.Odin 253-333-8998 BamBam Rubble bambam@aol.com Database w 7:00PM S.O.Elle 206-448-9876 Wilma Flintstone wfbrc.edu Database W 7.00PM S.Q.Elle 206-448-9876 Betty Rubbble br@gmail.com Hacking M 5:00PM S.N. Odin 253-333-8998 Hocking T 5.00 PM S.N.Odin 253-333-8998 Given the data in the table the best surrogate primary key for this table would be: none of the listed attributes. student, email, and instructor student, email, and class student, email, and day O instructor, phone

IT IS NOT STUDENT, EMAIL, and CLASS or

STUDENT, EMAIL, and DAY

Answer 1

Student Roster Student Email Class Days Time Instructor Phone Fred Flintstone ff@brc.edu Java PromeM 7.00PM P.R.O'Grammer 206-880-3232 Wilma Flintstone wf@brc.edu Java Promo M 7:00PM P.R. OʻGrammer 206-880-3232 Wlima Flintstone wf@brc.edu Database T 7.00PM S.O.Elle 206-448-9876 Barney Rubble br@brc.edu Database T 7:00PM S.Q.Elle 206-448-9876 BamBam Rubble br@bre.edu Hacking M 5:00PM S.N.Odin 253-333-8998 BamBam Rubble bambam@aol.com Database w 7:00PM S.O.Elle 206-448-9876 Wilma Flintstone wfbrc.edu Database W 7.00PM S.Q.Elle 206-448-9876 Betty Rubbble br@gmail.com Hacking M 5:00PM S.N. Odin 253-333-8998 Hocking T 5.00 PM S.N.Odin 253-333-8998 Given the data in the table the best surrogate primary key for this table would be: none of the listed attributes. student, email, and instructor student, email, and class student, email, and day O instructor, phone

Answer is none of the listed attributes. Reason is being that surrogate key is the key which is created by the system and not part of the columns in database.