plumiRelational databases: AQA GCSE Computer Science questions
Every AQA GCSE Computer Science exam question on 3.7.1 Relational databases, 2022–2025, with its mark scheme and examiner’s report.
Paper
All papers
Exam
All years
Calculations
Q20.1
The whole paper ↗Q20.2
The whole paper ↗Q20.3
The whole paper ↗Q18.1
The whole paper ↗Q18.2
The whole paper ↗Q18.3
The whole paper ↗Q18.4
The whole paper ↗Q14.1
The whole paper ↗Q14.2
The whole paper ↗Q14.3
The whole paper ↗Q18.1
The whole paper ↗Q18.2
The whole paper ↗Q18.3
The whole paper ↗Q18.4
The whole paper ↗Q09.1
The whole paper ↗Q09.2
The whole paper ↗
All 16 questions on Relational databases, as a list
- June 2025, Paper 2, Q20.1 (2 marks): Define the term relational database. [2 marks]
- June 2025, Paper 2, Q20.2 (2 marks): Define the term foreign key. [2 marks] DO NOT WRITE ON THIS PAGE ANSWER IN THE SPACES PROVIDED
- June 2025, Paper 2, Q20.3 (1 mark): State the name of the field from the TestResult table that is the primary key. [1 mark]
- June 2024, Paper 2, Q18.1 (1 mark): Define the term database. [1 mark]
- June 2024, Paper 2, Q18.2 (2 marks): Explain what is meant by data inconsistency within a database. [2 marks]
- June 2024, Paper 2, Q18.3 (2 marks): Define the term foreign key. [2 marks]
- June 2024, Paper 2, Q18.4 (1 mark): State the identifier of a field from the Actor table in Figure 8. [1 mark]
- June 2023, Paper 2, Q14.1 (2 marks): Shade two lozenges to show which of the following statements are benefits of relational databases. [2 marks] A All the information can be stored in one table. B
- June 2023, Paper 2, Q14.2 (1 mark): State one field in the Loan table that is a foreign key. [1 mark]
- June 2023, Paper 2, Q14.3 (1 mark): State the most suitable data type for the DepositPaid field in the Loan table. [1 mark]
- June 2022, Paper 2, Q18.1 (2 marks): Define the term relational database. [2 marks]
- June 2022, Paper 2, Q18.2 (1 mark): State one benefit of using relational databases. [1 mark]
- June 2022, Paper 2, Q18.3 (1 mark): State the name of the field from the Member table that is the most suitable to use as the primary key. [1 mark]
- June 2022, Paper 2, Q18.4 (1 mark): State the name of the field from the Award table that is a foreign key. [1 mark]
- Specimen, Paper 2, Q09.1 (1 mark): State the field in the Booking table that is a foreign key. [1 mark]
- Specimen, Paper 2, Q09.2 (1 mark): State the most suitable data type to use for the Complexity field. [1 mark]
Questions, mark schemes and examiner’s reports are © AQA, from their published past papers. Plumi isn’t affiliated with any exam board. Want whole papers? Full past papers.
Rather write your answers by hand on iPad? Plumi marks them against the same mark schemes.