Help Me/Question What Is Candidate Key, Super Key And Secondary Key?


Content Writer
  • Candidate Key : it ensures uniqueness and irreduceability i.e no proper subset of A has the uniqueness property.There could be multiple candidate keys however among those only 1 is choosen as primary key and other becomes alternat3 keys. No null value is allowed in candidate key column.
  • Super Key: A super key has uniqueness property and may or may not be irreduceable i.e a proper subset of A could have the uniqueness property.
  • Sencondary key: it is an attribute or combination of attributes that may not be a candidate key but classify the entity set on the particular characteristics.

Swati Mishra

Content Writer
A candidate key is subset of super key.A candidate key is single field or the least combination of fields that uniquely identifies each record in table.

and the super key is the combination of attributes.