|
|
Keywords:
Surrogate,
Unique,
Columns,
Row,
Attributes
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
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
a primary keys that is made up completely or in part from naturally occurring data in the tables
a property or combination of properties that is unique and non-null
a subset of attributes which occur in a table and act as a unique identifier
A key made from existing attributes. Opposite of a Surrogate key.
In relational model database design, a natural key is a candidate key that has a logical relationship to the attributes within that row.
|