Navdeep creates a table RESULT with a set of records to maintain the marks secured by students in Sem 1, Sem2, Sem3 and their division. After creation of the table, he has entered data of 7 students in the table.
Based on the data given above answer the following questions:
(i) Identify the most appropriate column, which can be considered as Primary key.
A primary key is an attribute which can uniquely identify the records in a relation/table.
In the given table, the column ROLL_NO can uniquely identify each record.
Therefore, ROLL_NO is the most appropriate column to be considered as the primary key.