Natural Key
(Redirected from natural key)
Jump to navigation
Jump to search
A Natural Key is an Unique Key that ...
- See: [[A Natural Key (Also Known as Business Key [1] ) is a Type of]], Database, Row (Database), Single Version of The Truth, , Unique Key, Relational Model, Candidate Key, Surrogate Key, Column (Database), Logical Schema.
References
2017
- (Wikipedia, 2017) ⇒ https://en.wikipedia.org/wiki/natural_key Retrieved:2017-4-17.
- A natural key (also known as business key [2] ) is a type of unique key, found in relational model database design, that is formed of attributes that already exist in the real world. It is used in business-related columns. [3] In other words, a natural key is a candidate key that has a logical relationship to the attributes within that row. A natural key is sometimes called domain key. [4]
The main advantage of a natural key over a surrogate key, which has no meaning outside the database environment, is that it already exists; there is no need to add a new, artificial column to the schema. Using a natural key (when one can be identified) also simplifies data quality: It ensures that there can only be one row for a key; this single version of the truth can be verified because the natural key is based on a real-world observation.
- A natural key (also known as business key [2] ) is a type of unique key, found in relational model database design, that is formed of attributes that already exist in the real world. It is used in business-related columns. [3] In other words, a natural key is a candidate key that has a logical relationship to the attributes within that row. A natural key is sometimes called domain key. [4]