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.

Example[edit]

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.

Also see[edit]

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 #