difference between superkey candidate and primary keys

Super key is the set of attributes in a table that can uniquely identifies a database tuple(row or record).

Candidate key is the minimal set of super key that can uniquely identifies a database record.

Primary key is one of the candidate keys. you can select any candidate key as the primary key. But in generally the candidate key which has meaningful attributes that uniquely will be taken as the primary key

Share Your Answers

The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.