AQA GCSE Computer Science 3.7 Relational Databases and SQL Complete Unit

Complete AQA GCSE Computer Science 8525 3.7 unit: 4 lessons, a free online SQL database task, work and homework booklets and an assessment.

Everything you need to teach AQA 3.7 Relational Databases and SQL, built around one consistent School Database (Teachers and Classes) that students use in every lesson, booklet and assessment. Every SQL answer has been checked by running the query.

4 lessons (74 editable PowerPoint slides)

1. Databases and Relational Databases (entities, attributes, fields, records, data types, flat files, data redundancy and inconsistency)
2. Keys and Relationships (primary, foreign and secondary keys, ERDs)
3. SQL: Selecting Data (SELECT, FROM, WHERE, ORDER BY, AND, OR, NOT)
4. SQL: Two Tables and Changing Data (two-table queries, INSERT, UPDATE, DELETE)

Every lesson includes

• Learning objectives and a retrieval starter (Do Now, retrieval grid or retrieval relay)
• Clear, editable diagrams: parts of a table, flat files vs relational databases, how keys link tables, how a SELECT query works, and more
• I do / We do / You do modelling and Green, Amber and Red independent practice
• AQA-style exam questions with a mark scheme
• A success check and a reflective plenary
• Teacher notes on every slide

Free online SQL database task
Students write real SQL queries in their browser against the School Database. No logins or downloads are needed. Each task checks itself instantly, with hints, and there’s a sandbox for practising INSERT, UPDATE and DELETE safely. Hosted at logicpage.co.uk.

Work booklet (20 pages) and homework booklet (16 pages), each with answers
Matching key terms, choosing data types, spotting redundancy, finding keys, drawing ERDs, predicting query output, writing and fixing SQL, two-table queries and changing data, plus mixed exam practice, key facts, a glossary and a checklist.

End of unit assessment (Word, with mark scheme)
50 marks, covering the whole unit, including a 6-mark extended question. The mark scheme gives line-by-line marks for every SQL answer, the query results and levels-of-response guidance.

What’s included: 4 PowerPoint lessons, 2 booklets (each with an answer copy) and an end of unit assessment with mark scheme.

Want more? Logic Page also makes complete AQA units for computer systems, networks, cyber security, programming and data representation, plus OCR GCSE and KS3 Computing. Search “Logic Page” on TES or visit www.logicpage.co.uk.