ExpertEasy1 markShort Answer
AQA GCSE · Question 18.3 · Relational databases and structured query language (SQL)
State the name of the field from the Member table that is the most suitable to use as the primary key.
State the name of the field from the Member table that is the most suitable to use as the primary key.
How to approach this question
A primary key must be a field that uniquely identifies each record in the table. Look at the fields in the `Member` table: `MemberID`, `FirstName`, `LastName`, `DateJoined`. Which of these is guaranteed to be unique for every single member?
Full Answer
MemberID
A **primary key** is a field in a table that uniquely identifies each record. It must have a unique value for each row and cannot be null.
Looking at the `Member` table fields:
- `FirstName`: Not unique (two people could be named Peter).
- `LastName`: Not unique (two people could have the last name Hill).
- `DateJoined`: Not unique (Zarah and Penny joined on the same day).
- `MemberID`: This field contains a unique number for each member (1, 2, 3, 4). It is specifically designed to be a unique identifier.
Therefore, `MemberID` is the most suitable primary key.
Common mistakes
✗ Choosing a field that is not guaranteed to be unique, like `FirstName` or `LastName`.
✗ Naming a field from the wrong table (e.g., `AwardID`).
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