Database Introduction - SSS 1 plan

LESSON PLAN

DATABASE INTRODUCTION

Subject	Digital Technologies
Class	SSS 1
Term	Third Term
Week	6
Topic	Database Introduction
Duration	80 Minutes (Double Period)
Date	________________

Behavioural Objectives

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

1. Define a database.
2. Explain the meaning and purpose of a Database Management System (DBMS).
3. Identify tables, records and fields in a database.

Instructional Materials

• Computer system or laptop.
• Whiteboard and markers.
• Sample student database table.
• Microsoft Access or another available database application.
• Projector, if available.

Previous Knowledge

Students have previously worked with organised information and spreadsheet tables. They may have encountered records such as students' names, admission numbers and examination scores.

Teaching Methods

Discussion, explanation, questioning, demonstration and guided practical activity.

Lesson Presentation

Time	Teacher's Activities	Students' Activities
5 minutes	Introduces the lesson by asking how a school keeps students' names, admission numbers and examination results organised.	Respond to questions and describe ways of keeping student information.
10 minutes	Defines a database and explains its importance. Gives examples from schools, hospitals, banks, libraries and shops.	Define a database and identify examples of databases in everyday life.
15 minutes	Explains a Database Management System (DBMS), gives examples such as Microsoft Access and MySQL, and describes its functions.	Explain the meaning and purpose of a DBMS and mention examples of database management systems.
15 minutes	Displays a sample student database table. Explains tables, records and fields using the table's rows and columns.	Identify the table, individual records and fields in the sample database.
15 minutes	Guides students in examining sample data. Introduces the primary key and demonstrates basic operations such as inserting, retrieving and updating records.	Identify a possible primary key and explain how database records can be added, found or updated.
10 minutes	Organises a classroom activity in which students label the fields and records in a sample table. Corrects errors and reinforces the difference between a database and a DBMS.	Label the fields and records, answer questions and explain the difference between a database and a DBMS.
10 minutes	Evaluates students through oral questions, reviews the main concepts and gives an assignment.	Answer evaluation questions and record the assignment.

Total Duration: 80 Minutes

Evaluation

1. Define a database.
2. What is a Database Management System?
3. Mention three examples of DBMS software.
4. Differentiate between a table, a record and a field.
5. Identify the fields and one complete record in a sample student database table.

Assignment

1. Explain the meaning of a database and state four benefits of using databases.
2. Define DBMS and list four examples.
3. Draw a student database table containing four fields and three records. Label the fields and identify one complete record.
4. Explain the purpose of a primary key in a database table.

Reference

CMPNOTE SSS 1 Digital Technologies Lesson Note: Database Introduction, Third Term, Week 6.