Question Constellation Sign up for free AQA · GCSE · Computer Science · Higher
Foreign key definition
Define the term foreign key.
Write your answer first. You can study the marking guidance whenever you need it.
Study the marking See what earns credit and compare it with a full-mark answer.
Marking points
- 1 Identifies a foreign key as a field in one table.
- 2 Links that field to a primary key in another table.
Full-mark answer
A foreign key is a field in one table whose values refer to a primary key in another table.
Why this answer loses marks
A variable used to link tables.
Use database structure precisely: it is a field related to a primary key in another table.