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: 2

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 database terminologies
  2. State the advantages and disadvantages 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 and explains database terminologies

Students pay attention and participates

STEP 3

DEMONSTRATION

She explains the advantages and disadvantages 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

Data base Terminologies

  1. Data:- these are raw facts about an items. It may be in words or text,

numbers, pictures and sound etc

  1. Field:- it is a collection of data with similar characteristic. It refers to the column of data in a table. It may be in form of words or text e.g name of student, sex , figures etc

admission numbers, phone numbers and address.

  1. Record:- this is the collection of data for a specific entity.
  2. Entity:- this refers to a person, object, an event or transaction e.g students, teachers, employee etc
  3. Data table ( or tables ) :- this is an arrangement of data in rows and columns e.g students database
  4. File:- it is a collection of related records
  5. Key:- this is a field used to sort or quickly retrieve information from a database e.g in a student records, admission number can be used as a key field.
  6. Index:- A summary table helps one to quickly look up the contents of any records in a database.
  7. Data base Administration:- It is an integration of file which comprised of one or more table e.g A collection of class file in a school.

 

ADVANTAGE OF DATABASE

  1. It reduces duplication of data’
  2. It improves data security
  3. It achieves data security
  4. Data and I formation are rapidly retrieved.

 

DISADVANTAGES OF DATABASE

  1. It leads to acquire a large hardware configuration
  2. The software DBMS ( Database Management System) is very expensive.
  3. It enquire an expert administration staff

EVALUATION:    1. Mention and explain four database terminologies

  1. State three advantages and disadvantages of database

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively