Question

$difference \: between \: primary \: key \: and \: candidate \: key \: + their \: defination$
​

Answer 1

Hey mate, here's your answer:-

Relationships are links between a field in one table and a field in another. The field with the same name in both the tables is used to link the tables. This field is called primary key in one table which uniquely identifies the records in the second table.

A candidate key is one unique column or a group of columns which can each qualify to be a primary key.

Hope you got the answer :-)