Software - Databases
Primary Key (1 of 2)


A primary key is a field which contains data which is unique for each record in a particular table.

For example, a library may have a database to store information about its stock of books:

© Microsoft Corporation

Considering each column in turn we can see that an author can have written more than one book, two different books may have the same title, a publisher can have published more than one book, and a year will have more than one book published in it.