Why are certain fields chosen to be the primary key in a database?

A Primary key is a field in a database that is used as an unique identifier for each record. Therefore the field that is chosen as the primary key has to be something that will be different for every record, for example the ISBN of a book or a customer ID number.

CB

Related Computing GCSE answers

All answers ▸

Calculate the file size in bits for a two minute sound recording that has used a sample rate of 1000 Hertz (Hz) and a sample resolution of 5 bits.


What is the result of this binary addition: 0110 + 0101 ?


Storage: Magnetic hard disc vs Solid state drive.


What is SQL? I know it's a 'query' language, but what does that mean?