Vlog

Please consent to cookies to view content.

' ); iframeDoc.close(); } } } } } const observer = new MutationObserver(switchSrc); observer.observe(document.documentElement, { childList: true, subtree: true, }); })();

Vlog

Resources Education Jobs Schools directory News Magazine Courses Log out Help
Home feed
My list
Courses My Jobs Job alerts Career preferences Resources Author dashboard
Settings
Edit account Log out
Home Resources Jobs Schools directory News Magazine Courses Register for free Log in Help

Home feed Edit account About us My products Vlog for schools Work for Vlog Log out
Databases and relational databases – AQA GCSE Computer Science

Databases and relational databases – AQA GCSE Computer Science

Subject: Computing

Age range: 14-16

Resource type: Lesson (complete)

Last updated

11 November 2026

docx, 38.13 KB
docx, 38.13 KB
docx, 38.89 KB
docx, 38.89 KB
pptx, 449.16 KB
pptx, 449.16 KB

Databases and relational databases lesson for AQA GCSE Computer Science (8525), with editable PowerPoint slides, a student worksheet and full answers. A relational database stores data in linked tables; students learn why it beats a flat file and how tables relate to each other.

Written for Paper 2 Computing concepts, section 3.7 Relational databases and SQL (spec 3.7.1.1, 3.7.1.2). Everything is editable, so you can adapt it to your class.

What’s included
  • PowerPoint lesson (13 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
AQ2.43 Databases and relational databases

By the end of the lesson students can:

  • Explain what a database is and why organisations use one
  • Explain what a relational database is: data held in separate tables linked by shared fields
  • Spot repeated data in a single table and split it into linked tables

Worksheet sections: A. Key words; B. Find the problems; C. Split the table; D. Exam-style questions; E. Challenge

Every lesson includes
  • Learning goals and a starter question
  • Clear explanations, diagrams and worked examples (Python 3 throughout, with AQA pseudo-code alongside so students can read exam algorithms)
  • 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
  • Bright, clear GCSE design, consistent across the whole course

These are independent resources written for the AQA GCSE Computer Science specification (8525, version 1.3), for exams from 2027. They are not produced or endorsed by AQA. Spec point numbers are our own numbering of the specification statements.

More lessons in this series

Last updated: November 2026.

Get this resource as part of a bundle and save up to 28%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

Relational databases and SQL – AQA GCSE CS (6 lessons)

6 ready-to-teach lessons for AQA GCSE Computer Science (8525): Relational databases and SQL. Every lesson has editable PowerPoint slides, a student worksheet and full answers, and the bundle costs less than buying the lessons one by one. A complete, ready-to-teach bundle for AQA GCSE Computer Science (8525): Section 3.7 Relational databases and SQL, in 6 bespoke lessons. Every lesson comes with: - **Editable PowerPoint slides**: goals, starter, explanations, diagrams, worked examples, a quick check, a task and an exit ticket, with teacher notes - **Student worksheet (Word)**: recall, applied practice and exam-style questions with marks - **Answer sheet (Word)**: full mark-scheme style answers Worth £29.94 if bought lesson by lesson. ## What's inside - **AQ2.43** Databases and relational databases - **AQ2.44** Tables, keys and redundancy - **AQ2.45** SQL: SELECT, FROM and WHERE - **AQ2.46** SQL: ORDER BY and two tables - **AQ2.47** SQL: INSERT, UPDATE and DELETE - **AQ2.48** SQL practice ## Why teachers use it - Mapped lesson by lesson to the specification, so coverage is easy to track - Python 3 throughout, with AQA pseudo-code alongside so students can read exam algorithms - Fully editable: adapt to your class, timings and school template - Works for teaching, revision, cover lessons and homework These are independent resources written for the AQA GCSE Computer Science specification (8525, version 1.3), for exams from 2027. They are not produced or endorsed by AQA. Spec point numbers are our own numbering of the specification statements. Last updated: November 2026.

£12.99

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

to let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.

£3.00
(no rating)0 reviews

Not quite what you were looking for?Search by keyword to find the right resource: