Question

what is is the difference between primary key and candidate key

Answer 1

primary key uniquely identifies each record in a table.it helps to reduce duplicacy of data.
a key that has the ability to. become primary key is called candidate key

Answer 2

Short notes on primary key and Candidate key:

(1) A primary key is a combination of columns that can uniquely identify a record. Any columns or set of columns that are a candidate to become PK are candidate key.

(2) A table can have only 1 primary key. A table can have more than 1 Candidate key.


Hope this helps!