Lesson Plan

Resources → Subject Notes → Computer Science → Notes
Lesson Plan
Grade: Date: 17/01/2026
Subject: Computer Science
Lesson Topic: Show understanding of how software tools found within a DBMS are used in practice
Learning Objective/s:
  • Describe the purpose of major DBMS tools such as DDL, DML, SQL, transaction control, indexing, views, stored procedures, triggers, backup/recovery, security and reporting.
  • Explain how each tool is applied in a typical business scenario.
  • Apply SQL statements to create, modify, query, and protect a sample database.
  • Demonstrate use of transaction control and indexing to ensure data integrity and performance.
  • Evaluate security roles and backup strategies for reliable database operation.
Materials Needed:
  • Projector and screen for slide demonstrations
  • Laptop with MySQL (or equivalent) installed
  • Sample database scripts (Employee, Product, Sales)
  • Worksheet with practice SQL tasks
  • Whiteboard and markers
  • Backup utility demo (mysqldump)
 Introduction:
Begin with a short video clip showing a real‑world inventory system, then ask students what database functions they think make it work. Review key DBMS terminology from the previous lesson and state that today they will see each tool in action and be able to choose the right one for a given problem.
Lesson Structure:
  1. Do‑now (5') – quick quiz on DBMS terminology to activate prior knowledge.
  2. Mini‑lecture (15') – overview of DBMS software tools with concise examples (DDL, DML, SQL, transactions, indexing, etc.).
  3. Guided coding (20') – students run provided scripts to create tables, insert data, and write simple SELECT queries.
  4. Transaction & indexing activity (10') – simulate a sales transaction, create an index on the sales date, discuss ACID properties.
  5. Security & backup demo (10') – create a role, grant privileges, and execute a mysqldump backup.
  6. Reporting & stored procedure task (10') – write a procedure that generates a monthly sales report and run it.
  7. Exit ticket (5') – each student writes one sentence describing the tool they found most useful and why.
Conclusion:
Recap the suite of DBMS tools covered and highlight how they interlock to build robust applications. Collect the exit tickets and address any lingering misconceptions. For homework, students will extend the sample database by adding a new view and a trigger, then document the business rule it enforces.