Super key

From Oracle FAQ
Jump to: navigation, search

A super key is a column or set of columns that uniquely identifies a row within a table.

[edit] Example

Given table: EMPLOYEES{employee_id, firstname, surname, sal}

Possible superkeys are:

  • {employee_id}
  • {employee_id, firstname}
  • ...
  • (employee_id, firstname, surname, sal}

Only the the minimal superkey - {employee_id} - will be considered as a candidate key.

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #