Super key
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
A super key is a column or set of columns that uniquely identifies a row within a table.
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.
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 | # |
