Cambridge A Level Computer Science 9618 – P1.46 From files to relational databases

Bespoke, fully editable lesson for Cambridge International AS & A Level Computer Science (9618): P1.46 From files to relational databases. Slides, worksheet and full answers.

Written for Paper 1 Theory Fundamentals, section 8 Databases (syllabus 8.1.1, 8.1.2, 8.1.3). Everything is editable, so you can adapt it to your class.

What’s included

• PowerPoint lesson (16 slides) with teacher notes on every slide
• Student worksheet (Word), ready to print or edit
• Answer sheet (Word) with mark-scheme style answers for every question

P1.46 From files to relational databases

By the end of the lesson students can:

• Explain the limitations of storing data in separate files
• Describe how a relational database overcomes those limitations
• Use the terms of the relational model, including the different kinds of key

Worksheet sections: A. Key words; B. Spot the problems; C. Identify the keys; D. Exam-style questions; E. Challenge

Every lesson includes

• Learning goals and a starter question
• Clear explanations, diagrams and worked examples (Cambridge pseudocode, as in the 2027–2029 pseudocode guide, with Python alongside)
• A quick check and a “your turn” task linked to the worksheet
• Exam-style questions with marks, and an exit ticket

Format

• PowerPoint (.pptx) and Word (.docx), fully editable
• Works in PowerPoint and Google Slides
• Calm, muted sixth-form design, consistent across the whole course

These are independent resources written for the Cambridge International AS & A Level Computer Science syllabus (9618) for examination in 2027, 2028 and 2029. They are not produced or endorsed by Cambridge University Press & Assessment. Syllabus point numbers are our own numbering of the syllabus statements.