ExpertEasy1 markShort Answer
AQA GCSE · Question 18.4 · Relational databases and structured query language (SQL)
State the name of the field from the Award table that is a foreign key.
State the name of the field from the Award table that is a foreign key.
How to approach this question
A foreign key is a field in one table that is the primary key in another table. It is used to link the two tables together. Look at the fields in the `Award` table and see which one corresponds to the primary key of the `Member` table.
Full Answer
MemberID
A **foreign key** is a field (or collection of fields) in one table that uniquely identifies a row of another table. In essence, a foreign key is a primary key from another table that has been included to create a link between them.
- The primary key of the `Member` table is `MemberID`.
- The `Award` table also contains a field called `MemberID`.
- This `MemberID` field in the `Award` table is used to link each award to the specific member who received it.
Therefore, `MemberID` in the `Award` table is the foreign key.
Common mistakes
✗ Choosing the primary key of the `Award` table (`AwardID`).
✗ Choosing a field that is not a key, like `AwardName`.
✗ Naming a field from the wrong table.
Practice the full AQA GCSE Computer Science Paper 2
46 questions · hints · full answers · grading
More questions from this exam
Q01.1Convert the binary number 11010100 into decimal.EasyQ01.2Convert the binary number 10111001 into hexadecimal. You should show your working.MediumQ01.3State the largest decimal number that can be represented using 6 bits.EasyQ02.1Add together the following three binary numbers and give your answer in binary.
00110110
1001...MediumQ02.2Apply a binary shift three places to the right on the bit pattern 10101000. Give the result using...Easy