Cambridge Computer Science SQL & Databases Complete Lesson Pack | PPT, Worksheet, Quiz & Mark Scheme - Complete Lesson Pack for Cambridge IGCSE, AS & A-Level Computer Science

What’s in the bundle:

1. SQL_Databases_Lecture.pptx — 15 premium slides covering:

Learning objectives (numbered card layout)
Key terms (field, record, primary key, foreign key, DBMS)
ERD components with a live Student↔Course diagram + cardinality key
Normalisation section (1NF/2NF/3NF) with worked example showing an unnormalised → 3NF table
SQL syntax reference (SELECT, JOIN, GROUP BY, INSERT/UPDATE — all with dark code blocks)
SQL worked example (step-by-step JOIN query build)
DBMS vs Flat Files (6 comparison cards)
Practice questions slide
Summary slide

1. SQL_Worksheet.docx — 50-mark student worksheet with:

Section A: 5 MCQs
Section B: Short answer (define FK, spot normalisation errors, fix buggy SQL, write JOIN queries)
Section C: ERD drawing task, extended normalisation essay, DBMS comparison essay
Answer lines + marks boxes throughout

1. SQL_ClassActivity.docx — 50-minute group task (“Pageturn Books” scenario):

Real messy spreadsheet to diagnose
ERD design task
3 SQL queries to write (filtering, JOIN, GROUP BY + revenue)
Group presentation preparation
Extension tasks for A Level

1. SQL_Answers_MarkingScheme.docx — Full teacher marking scheme:

MCQ answers
Point-by-point mark scheme for every question
Correct SQL for all queries
Level descriptors (L1–L4) for extended answers
Marked “NOT FOR STUDENT DISTRIBUTION”

Aligned with:
• Cambridge IGCSE Computer Science 0478 / 0984
• Cambridge AS & A-Level Computer Science 9618
• Grade [9 ,10 / 11 ]

Suggested lesson time: [60 / 90] minutes
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.