For a student table maintained by a school/college, where each student is…
2019
For a student table maintained by a school/college, where each student is assigned a unique admission number by the institution, which of the following is the most appropriate primary key?
- A.
UID number
- B.
Admission number
- C.
Account number
- D.
PAN
- E.
None of these
Attempted by 1774 students.
Show answer & explanation
Correct answer: B
Admission number is the most appropriate primary key here. In a school/college student table, the admission number is assigned by the institution, is unique for each student within that institution, and is stable inside the student database.
UID number is an external identifier and is not the best database-design choice for this institutional table. Account number and PAN are also unsuitable because they may not apply to every student.