OCR Computing A-Level Revision

Keys (3.9.c)

Each record needs to be uniquely identifiable. Therefore, a key needs to be used which will always be unique. This is known as the primary key. Other fields which are always unique (but are not the primary key) are known as secondary keys. A foreign key is where a primary key is used in one table to "link back" to a row in another table.