Lesson Notes By Weeks and Term - Senior Secondary 3

Database management I

Term: 1st Term

Week: 8

Class: Senior Secondary School 3

Age: 17 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Computer studies and ICT

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 III 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 Network cables and connectors

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

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

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively