plumiDatabase Concepts: CAIE A‑Level Computer Science questions
Every CAIE A-Level Computer Science exam question on 8.1 Database Concepts, June 2024 and the specimen papers, with its mark scheme and examiner’s report.
Paper
All papers
Exam
All years
Calculations
Q6(a)
The whole paper ↗
Q3(a)(i)
The whole paper ↗
Q3(a)(ii)
The whole paper ↗Q3(a)(iii)
The whole paper ↗
All 4 questions on Database Concepts, as a list
- June 2024, Paper 1, Q6(a) (6 marks): Create a 3-table design for this database normalised to Third Normal Form (3NF). Give your table design in the format: TableName(PrimaryKey, Field1, Field2, …)
- Specimen, Paper 1, Q3(a)(i) (3 marks): Draw an entity-relationship (E-R) diagram for the normalised tables. [3]
- Specimen, Paper 1, Q3(a)(ii) (3 marks): Complete the table to identify the primary key and foreign key(s) for each of the tables you identified in part (a)(i). If the table has no foreign key(s), writ
- Specimen, Paper 1, Q3(a)(iii) (2 marks): Explain why the holiday database is in Third Normal Form (3NF). [2]
Questions, mark schemes and examiner’s reports are © Cambridge University Press & Assessment, 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.