AQA GCSE Computer Science · 8525
Paper 2
Revise: Concept of a Relational DatabaseA primary key uniquely identifies a record in a table. In the Student table,
StudentIDidentifies a particular student; in the Test table,TestIDidentifies a particular test. Names are less suitable for identifying students because different students can share a name.- Revise: Database Terminology
A field whose value uniquely identifies each record within a table. A primary key can also consist of a combination of fields.