Candidate Key | Super Key in DBMS
Primary Key is a unique and non-null key which identify a record uniquely in table. A table can have only one primary key.
Candidate key is also a unique key to identify a record uniquely in a table but a table can have multiple candidate keys.
In this video I have explained how to find Candidate key with examples and also difference between Super Key and Candidate Key