Revision: Databases and SQL

Lesson objectives

By the end of the week, learners should be able to:

1. Recall database concepts, schema design and SQL basics across all terms.
2. Identify weak areas and request targeted reteaching.
3. Complete a consolidated database review worksheet.
4. Practise recall under timed conditions.
5. State one improvement action per flagged weakness.

Key vocabulary

• Database system: software storing, managing and retrieving records.
• Schema: the design defining tables, fields and relationships.
• SQL: the structured query language controlling relational databases.
• CREATE TABLE: SQL syntax declaring a new table.
• Primary key: a unique identifier for each record within a table.
• Foreign key: a field linking a row in one table to another.
• Constraint: a rule limiting allowed data values.
• Consolidated review: bringing together previously taught material into one document.
• Weak area: a topic where recall falls below target.
• Improvement action: a concrete step addressing a weakness.

Common misconceptions

• "Review means rereading." Review means testing and reapplying, not passive reading.
• "Everything learned must reappear in the database revision." The revision covers enough material to demonstrate retention.
• "A database is just a spreadsheet." Databases enforce constraints and relationships that spreadsheets ignore.

Teacher activities

1. Starter: display the database week titles and ask pairs to recall one concept each without notes.
2. Share the recalled concepts and flag the three weakest database topics.
3. Model writing one consolidated database review item step by step.
4. Run a timed recall quiz and mark it as a class.
5. Assign an improvement action per each flagged weakness.
6. Close with the revision plan announcement.

Student activities

1. Recall one database concept per week without notes and note any misses.
2. Identify your weakest database topic and note two improvement actions.
3. Complete the consolidated database review worksheet.
4. Take the timed recall quiz and self-mark honestly.
5. Plan two improvement actions targeting two weaknesses.
6. Submit the review, quiz and plan together.

Practical / learning evidence

A completed consolidated database review worksheet, a self-marked timed recall quiz and a revision plan with two improvement actions. All three submitted for marking.

Resources and preparation

Printed review worksheet, sample quiz sheets and a revision-plan template. Offline route: paper versions, no device needed. Display examples carefully and avoid exposing sensitive learner information.

Assessment for learning

Check the review worksheet for completeness across prior database terms. Mark the self-quiz for honest scoring. Evaluate the revision plan for two specific, actionable improvements. Flag any learner who lists no weaknesses.

Inclusion and homework

Provide the review prefilled for the first item and allow oral completion of the rest. Allow extra time on the timed quiz. Extend confident learners with four more review items and a second plan homework. Homework: write two sentences describing how prior database knowledge supports advanced work.