Question

Student Roster Student Fred Flintstone ff@brc.edu Wilma Flintstone wf@brc.edu Wlima Flintstone wf@brc.edu Barney Rubble BamBam Rubble br@brc.edu BamBam Rubble bambam@aol.com Wilma Flintstone wf@brc.edu Betty Rubbblebr@gmail.com Email Class Java Pramg M Java Pramg M Database Database Hacking Database Database Hacking Hacking I T Time Instructor Phone 7:00PM PRO'Grammer206-880-3232 7:00PM 206-880-3232 ammer 7:00PMS.9.E 206-448-9876 br@brc.edu 7:00PMS9.Elle 206-448-9876 M 5:00PMS.NOdin 253-333-8998 7:00PM S.Q.Elle 7:00PMS.9.E 5:00PMS.N. Odin 206-448-9876 206-448-9876 253-333-8998 5:00 PM 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

   

instructor, phone

Answer 1

Answer:

student, email, and day

Explanation:

The combination of student, email, and day columns can be used to uniquely identify the rows in the table.