Computer Studies - Junior Secondary 3 - Database

Database

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Comprehensive Lesson Plan and Notes
  3. Junior Secondary 3
  4. Database

Term: 2nd Term

Week: 3

Class: Junior Secondary School 3

Age: 14 years

Duration: 40 minutes of 2 periods each

Date:

Subject:      Computer studies

Topic:-       Database

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

  1. Mention and explain the forms of database

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

INSTRUCTIONAL MATERIALS: Videos, loud speaker, textbook, pictures

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

PRESENTATION

TEACHER’S ACTIVITY

STUDENT’S ACTIVITY

STEP 1

INTRODUCTION

The teacher revises the previous lesson on database

Students pay attention

STEP 2

EXPLANATION

She mentions the forms of database 

Students pay attention and participates

STEP 3

DEMONSTRATION

She explains the forms 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

  1. Flat file model:- This refers to database that consist of a single table

(rows and column), it consist of small and fixed number of fields e.g

Address books, Class Register, Students Admission Kist, Staff Nominal

Roll.

 

Route No.

Miles

Activities

RECORD 1

1 – 95

12

Overlay

RECORD 2

1 -495

05

Parching

RECORD 3

SR – 301

33

Crack Seal

 

  1. Relational File Model:- This is the collection of related tables that are

linked together through a common field.

Relational database management system is a software package used to create relational database are called Microsoft Access, Oracle etc

  1. Hierarchical Model:- This is an organization of a data/records in a free

structure. This implies that a records can have repeated information where data in a series of records have a set of field valves attached to it

  1. Network Model:This model organizes data using two fundamental construct, called records and sets. Records contain fields, and sets define one-to-many relationships between records: one owner, many members.

 

EVALUATION:    1. List and explain the forms of database

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively