Question

Alice has made a database table in Access containing fields_name, Class, Roll_No. and Contact_no. She set the primary key for the field ‘Student_name’. Has she done the right thing by setting the primary key for this field?

Answer 1

Answer:

No as she should have put the Roll_No. as the primary key as there is no chance of this to be reapeated unlike name.