Lesson Plan

Resources → Subject Notes → Computer Science → Notes
Lesson Plan
Grade: Date: 17/01/2026
Subject: Computer Science
Lesson Topic: Show understanding that the DBMS carries out all queries and maintenance of data using its DML
Learning Objective/s:
  • Describe the role of DML in executing queries and maintaining data within a DBMS.
  • Distinguish between DDL and DML commands and their effects on schema versus data.
  • Explain the DBMS processing pipeline for DML statements (parsing, optimization, execution, transaction management, integrity enforcement).
  • Apply transaction control (COMMIT, ROLLBACK) to ensure ACID properties during DML operations.
  • Write basic DML statements (SELECT, INSERT, UPDATE, DELETE) in a simple database scenario.
Materials Needed:
  • Projector and screen
  • Whiteboard and markers
  • Student handout summarising DDL vs DML commands
  • Lab computers with a SQL editor (e.g., MySQL Workbench or SQLite)
  • Sample database script (Student table)
  • Worksheet with DML practice questions
 Introduction:
Begin with a quick poll asking students which SQL statements they used last week, then link those to the idea that only DML actually changes data. Highlight that today’s success criteria are to explain how the DBMS processes DML and to demonstrate basic DML statements with proper transaction control.
Lesson Structure:
  1. Do‑now (5') – Short quiz on DDL commands from the previous lesson.
  2. Mini‑lecture (10') – Introduce DML purpose, contrast with DDL, and present the DML processing pipeline diagram.
  3. Guided demo (15') – Live coding of SELECT, INSERT, UPDATE, DELETE in MySQL; point out parsing, optimization, and execution steps.
  4. Pair activity (15') – Students write DML statements for a given university‑database scenario and add COMMIT/ROLLBACK logic.
  5. Check for understanding (5') – Exit ticket: one sentence describing how the DBMS ensures data integrity for a DELETE operation.
  6. Recap & homework (5') – Summarise key points and assign the worksheet with additional DML queries.
Conclusion:
Review the five stages of the DML pipeline and how transaction control safeguards data. Collect the exit tickets to gauge understanding, then remind students to complete the worksheet at home, focusing on writing correct COMMIT/ROLLBACK blocks for multi‑step DML tasks.