For example, account number is often a primary key. A "composite primary key" or "super key" is made up of two or more columns such as account number + name. See candidate key. THIS DEFINITION IS ...

Sometime primary keys are obvious, for example a car license plate could be used to uniquely identify cars. Often, primary keys are less obvious and it is necessary to create a unique value ...