Databases. Database Management System (DBMS) , Data Definition Language (DDL) and Data Manipulation Language (DML) , Cambridge IGCSE & A-Level 9618 | AQA | OCR | GCSE Computer Science

Databases, DDL, DML | CS PPT +Worksheets +Activity + Mcq Quiz + Answers_Marking Scheme

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

DB_PPT
18-slide lecture deck — File-based limitations, DBMS solutions, 3-schema model, DDL (CREATE/ALTER/DROP), DML (SELECT/INSERT/UPDATE/DELETE), JOINs, keys & constraints, ACID, worked SQL scripts, practice & summary slides

DB_Worksheet
50-mark structured worksheet — diagram labelling, table completion, DDL writing, DML trace tables, JOIN queries, ACID property table

DB_Activity
3 class activities — File System Disaster Simulation, SQL Query Builder puzzle, ACID Card Sort & discussion

DB_MCQ_Quiz
15 MCQ questions with answer + explanation slides, colour-coded options, score band summary

DB_Answers_Marking_Scheme
Full teacher mark scheme — model SQL answers, accept/reject guidance, activity discussion notes, MCQ key

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.