Lesson Plan

Resources → Subject Notes → Computer Science → Notes
Lesson Plan
Grade: Date: 17/01/2026
Subject: Computer Science
Lesson Topic: Show understanding of and use the terminology associated with a relational database model
Learning Objective/s:
  • Describe key relational‑database terminology (tables, rows, columns, primary/foreign keys, relationships, normalization, SQL).
  • Explain how primary and foreign keys establish links between tables and the impact of different relationship cardinalities.
  • Apply first‑, second‑, and third‑normal form rules to a simple table to reduce redundancy.
  • Write basic SQL statements (CREATE, INSERT, SELECT with JOIN) that demonstrate correct use of the terminology.
Materials Needed:
  • Projector or interactive whiteboard
  • Computer with a relational DBMS (e.g., MySQL, SQLite) installed
  • Printed handout of key terminology and sample ER diagram
  • Worksheet with normalization and relationship exercises
  • Sample SQL script saved on USB/online drive
 Introduction:
Begin with a quick poll: “Where do you see databases in everyday life?” Connect responses to the idea that data is organized in tables. State that by the end of the lesson students will be able to name and use core relational‑database terms and demonstrate them in SQL queries.
Lesson Structure:
  1. Do‑Now (5’) – Students list three real‑world examples of databases on a sticky note.
  2. Direct Instruction (10’) – Teacher presents key terminology with the ER diagram on screen, highlighting primary/foreign keys and relationship types.
  3. Guided Practice (12’) – Walk through the Student‑Course example, identifying keys and drawing the relationship.
  4. Normalization Activity (10’) – Small groups convert a denormalised table to 1NF, 2NF, then 3NF using the worksheet.
  5. SQL Demo (8’) – Live coding of CREATE, INSERT, and a JOIN SELECT query; students follow along on their computers.
  6. Check for Understanding (5’) – Quick quiz (Kahoot or paper) on terminology definitions.
  7. Wrap‑Up (5’) – Review key points and answer lingering questions.
Conclusion:
Recap the main terms and how they fit together in a relational model. Students complete an exit ticket: write one definition and give a short example for either primary key, foreign key, or normalization. Assign homework to design a simple ER diagram for a personal hobby database and draft corresponding SQL CREATE statements.