Question

What is the difference between primary key and secondary key?

Answer 1

Answer:

In this case we have “ID” and “Name, Address” as Candidate Key, we will consider “ID” Key as a Primary Key as the other key is the combination of more than one attribute. Secondary key: A field or combination of fields that is basis for retrieval is known as secondary key. Secondary key is a non-unique field.