Natural key
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
A natural key is a key made from existing attributes - the opposite of a Surrogate key.
Some natural key examples:
- National ID number/ Social Security Number
- Employee's Salary number
- Car registration number
- Publication's ISBN
- City name
- Airport name
Also see
- Surrogate key - generated key values
| 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 | # |
