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
Answered by Corey B. Computing tutor

1932 Views

See similar Computing GCSE tutors

Related Computing GCSE answers

All answers ▸

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


Describe the differences between a binary and linear search algorithm.


James would like to store a video clip that is 20 frames per second and has a duration of 76 seconds. The resolution of this video is 1280x720 with a colour depth of 24 bits. Calculate the storage requirement for the uncompressed video clip.


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.


We're here to help

contact us iconContact ustelephone icon+44 (0) 203 773 6020
Facebook logoInstagram logoLinkedIn logo

MyTutor is part of the IXL family of brands:

© 2025 by IXL Learning