Natural key

A natural key (also known as business key or domain key) is a type of unique key in a database formed of attributes that exist and are used in the external world outside the database (i.e. in the business domain or domain of discourse). In the relational model of data, a natural key is a candidate key and is therefore a functional determinant for all attributes in a relation. Examples of natural keys could include: * Purchase order number * Flight number * Login name * Vehicle registration number * Social Security number * Passport number * University ID number

Natural key

A natural key (also known as business key or domain key) is a type of unique key in a database formed of attributes that exist and are used in the external world outside the database (i.e. in the business domain or domain of discourse). In the relational model of data, a natural key is a candidate key and is therefore a functional determinant for all attributes in a relation. Examples of natural keys could include: * Purchase order number * Flight number * Login name * Vehicle registration number * Social Security number * Passport number * University ID number