SQL & Databases | CS PPT + Worksheets + Activity + Mcq Quiz + Answers_MarkingScheme

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”