Definitions for "Natural Key" Add To Word List
Login or Register  | Word Lists | Search History

a column or columns that are chosen by the business to uniquely identify records, and are allowed by the data analyst because they are considered to be stable enough to become the primary identifier
Helpful?           0
a piece of data (one or more columns of an entity) that uniquely identify that entity, and distinguish it from any other row in the table
Helpful?           0
a primary keys that is made up completely or in part from naturally occurring data in the tables
Helpful?           0
a property or combination of properties that is unique and non-null
Helpful?           0
a subset of attributes which occur in a table and act as a unique identifier
Helpful?           0
A key made from existing attributes. Opposite of a Surrogate key.
Helpful?           0
In relational model database design, a natural key is a candidate key that has a logical relationship to the attributes within that row.
Helpful?           0