Advanced Database Management - SSS 3 Plan

LESSON PLAN

SECOND TERM: ADVANCED DATABASE MANAGEMENT

Item	Details
Subject	Digital Technologies
Class	SSS 3
Term	Second Term
Week	2
Topic	Advanced Database Management
Duration	80 Minutes (Double Period)
Date	________________

1. Learning Objectives

By the end of the lesson, students should be able to:

1. Explain the meaning and purpose of SQL.
2. Identify common SQL commands and state their uses.
3. Write simple SQL queries to retrieve database records.
4. Use the WHERE clause and logical operators to filter records.
5. Sort query results using ORDER BY.
6. Explain how SQL queries and aggregate functions can be used to generate simple database reports.

2. Previous Knowledge

Students have prior knowledge of databases, tables, records and fields. They understand that databases are used to store and organise information. This lesson builds on that knowledge by introducing SQL commands and queries.

3. Instructional Materials

• Computer systems or laptops, where available.
• Database software or an SQL practice environment, where available.
• Projector or display screen.
• Sample Students database table.
• Whiteboard and markers.
• Prepared SQL examples and printed worksheets.

4. Teaching Methods

Explanation, questioning, discussion, demonstration, guided practice and problem-solving activities.

5. Presentation

Stage / Time	Teacher's Activities	Students' Activities
1. Introduction 8 minutes	Reviews the meaning of a database, table, record and field. Asks how a teacher could find all students who scored above 70 in an examination. Introduces Advanced Database Management.	Answer questions and explain how information can be retrieved from a database.
2. Introduction to SQL 10 minutes	Explains SQL as Structured Query Language and describes its role in retrieving and managing data in relational databases. Introduces common SQL commands.	Take notes, define SQL and identify its uses in database management.
3. Basic SQL Commands 12 minutes	Demonstrates SELECT, INSERT INTO, UPDATE, DELETE and CREATE TABLE. Explains the purpose of each command using simple examples.	Observe the examples and state the function of each SQL command.
4. Retrieving and Filtering Records 14 minutes	Demonstrates SELECT queries using specific fields and the WHERE clause. Explains comparison operators and the AND and OR operators with sample student records.	Write queries to retrieve selected fields and filter students according to their classes or scores.
5. Sorting and Database Reports 12 minutes	Explains ORDER BY with ASC and DESC. Introduces COUNT(), AVG(), MAX() and MIN(), showing how these functions can summarise database records for simple reports.	Identify appropriate commands for sorting records, counting students and calculating average scores.
6. Practical Activity 16 minutes	Guides students to use a sample Students table to write queries for displaying all records, filtering scores above 70, sorting scores in descending order and counting student records. Where computers are unavailable, provides a written exercise.	Write and, where possible, execute the queries. Compare results and correct mistakes with guidance.
7. Conclusion and Evaluation 8 minutes	Summarises SQL commands, filtering, sorting and report generation. Asks oral questions to assess students' understanding.	Answer questions and summarise the main uses of SQL.

Total Duration: 80 Minutes

6. Evaluation

1. What is SQL, and what is its full meaning?
2. Mention four common SQL commands and state their uses.
3. What is the purpose of the WHERE clause?
4. Differentiate between the AND and OR operators.
5. Explain the function of ORDER BY.
6. What is a database report?
7. State the functions of COUNT() and AVG().
8. Write an SQL query to display the names and scores of students who scored at least 70, arranging the results from highest to lowest.

7. Assignment

Using a sample database table named Students with the fields StudentID, Name, Class and Score, write SQL queries to:

1. Display all records in the table.
2. Display only the Name and Score fields.
3. Find students whose scores are below 50.
4. Display records in descending order of score.
5. Count the total number of student records.
6. Calculate the average score.

8. References

• SSS 3 Digital Technologies Scheme of Work, Second Term, Week 2.
• Digital Technologies class notes and practical materials on database management and SQL.