Referential Integrity & Constraints | Cambridge IGCSE & A-Level 9618 | AQA | OCR | GCSE Computer Science | PPT + Worksheets + Activity + MCQ Quiz + Answer Marking Scheme

Also suitable for AQA GCSE Computer Science, OCR GCSE Computer Science, Edexcel Computer Science and A-Level Computer Science teachers.

Referential Integrity & Constraints — Premium Bundle

1. Core Lecture PPT (30 slides) — Forest green / mint theme (distinct from VPN bundle):

Learning objectives (6 outcomes, all exam boards)
Relational database recap → 4 types of data integrity
All 6 constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK, DEFAULT — each with definition, rules, and SQL
Constraints quick-reference comparison table (slide 12)
Referential integrity defined: valid vs invalid FK, orphaned records problem
Referential actions: CASCADE, SET NULL, RESTRICT, SET DEFAULT — with use cases
Annotated SQL CREATE TABLE (colour-coded by constraint type) + ALTER TABLE
Library database case study with 3-table schema
Benefits vs limitations evaluation
Common constraint error messages + fixes
Practice questions slide + exam technique guide + glossary + summary

1. **Student Worksheet (40 marks) **— Section A: constraint matching + referential actions table · Section B: 4 short-answer questions · Section C: SQL writing tasks (CREATE TABLE + ALTER TABLE) · Section D: 8-mark hospital database extended response

3.**Class Activity Pack **— 4 activities: Spot the Violation (constraint error identification table), Database Design Challenge (library schema + SQL), Referential Action Role Play (simulate CASCADE/SET NULL/RESTRICT), Constraints Debate (strict vs flexible enforcement)

4.** MCQ Quiz **— 20 questions from GCSE recall to A-Level evaluation level, covering all constraint types and referential actions

1. Answers & Marking Scheme — Full model answers with level descriptors, annotated SQL solutions, MCQ answer key with explanations, grade boundary table for both assessments

All worksheets are print-ready

Fully editable resources.

Great for: classroom teaching, revision lessons, flipped learning, homework tasks.

If you found this useful, please leave a review. it really helps!

Check out my other resources and bundles in my TES shop.