AQA GCSE Computer Science · 8525
Paper 2
A field in one table that refers to the primary key of another table, allowing related records to be linked.
Revise: Concept of a Relational DatabaseA foreign key refers to a primary key in another table. In StudentTest,
StudentIDlinks a result to the correct student, whileTestIDlinks it to the correct test.- Revise: Database Terminology
A field containing a primary-key value from another table, linking its record to a particular record in that other table.