Question

Mrs. Sharma is the classteacher of Class ‘XII A’. She wants to create a table ‘Student’ to store details of her class.

(i) Which of the following can be the attributes of Student table? 

(a) RollNo 

(b) ‘Amit” 

(c) Name 

(d) 25

(ii) Name the Primary key of the table ‘Student’. State reason for choosing it.

Answer 1

(i) RolINo, Name can be the attributes of Student table.

(ii) Primary key of the table Student is RolINo, because RolINo is a field in Student table which uniquely identifies each rows/records in a database table.