Lesson Notes By Weeks and Term - Senior Secondary 1

Term: 3rd Term

Week: 8

Class: Senior Secondary School 1

Age: 15 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Database Management I

SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to

1. Define database and database management(DBMS)
2. State the benefits of database
3. Give examples of database

INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source

INSTRUCTIONAL MATERIALS: Videos, loud speaker, pictures, Data Processing for senior Secondary Education by Hiit Plc, WAPB Computer Studies for Senior Secondary I by Adekunle et al, On-line Materials.

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

PRESENTATION	TEACHER’S ACTIVITY	STUDENT’S ACTIVITY
STEP 1 INTRODUCTION	The teacher reviews the previous lesson on Spreadsheet	Students pay attention
STEP 2 EXPLANATION	He explains the meaning of database and database management. He also explains the functions of database	Students pay attention and participates
STEP 3 DEMONSTRATION	He lists some examples of database	Students pay attention and participate
STEP 4 NOTE TAKING	The teacher writes a summarized note on the board	The students copy the note in their books

 

NOTE

DATABASE MANAGEMENT

A database is a structured collection of interrelated data. It is a collection of data ordered and structured in a way that data can be easily accessed and managed.

A database management system (DBMS) is application software that is used to create, maintain and manage a database. MS Access database has the extension “.accdb’.

The smallest unit of data representation is called a bit.

A character is made up of 1 byte i.e. 8 bits.

A field consists of a group of characters.

A record is a collection of related fields.

File is a collection of related records and database is a collection of related files.

 

Benefits of a DBMS

1. Creation of database
2. Efficient data access
3. Data administration
4. Data integrity and security
5. Concurrent access and crash recovery
6. Data manipulation
7. Data transformation/modification/editing
8. Report generation/presentation

 

Examples of DBMSs

1. Microsoft Access            
2. Informix                         
3. MySQL       
4. Oracle
5. Ingress
6. FoxBase
7. IBM Dbase(III & IV)
8. MS SQL Server             
9. Paradox

EVALUATION:    1. Define database and database management

2. State the benefits of database
3. List some examples of database

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively