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 ...

Often, primary keys are less obvious and it is necessary to create a unique value – often an ID number. A primary key is a guaranteed way of uniquely identifying each record. In the school ...