Subject Table

Department Table

-Refer to the tables in Q2.The best attribute to be chosen as the primary key for the Lecturer Table is:
A)Surname
B)Surname and Given_Name
C)Lecturer_Code
D)Given _Name

Question

Subject Table
  
Department Table
 
-Refer to the tables in Q2.The best attribute to be chosen as the primary key for the Lecturer Table is:
A)Surname 
B)Surname and Given_Name 
C)Lecturer_Code 
D)Given _Name

Quizplus · Accepted Answer

The Lecturer_Code would be the best attribute to use as the primary key for the Lecturer Table, as it is a unique identifier for each lecturer and does not have the potential to change over time, unlike a person's name (surname and given name).

Subject Table Department Table