A table named School (containing data of students of the whole school) is created, where each record consists of several fields including Admission No (Admission Number), Roll No (Roll Number), Name. Which field out of these three should be set as the primary key and why?

A table named School (containing data of students of the whole school)

1.	A table named School (containing data of students of the whole school) is created, where each record consists of several fields including Admission No (Admission Number), Roll No (Roll Number), Name. Which field out of these three should be set as the primary key and why?
Answer» AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.