Lesson Notes By Weeks and Term - Senior Secondary 2

Normal form I

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Lesson Notes By Weeks and Term
  3. Senior Secondary 2
  4. Normal form I

Term: 1st Term

Week: 6

Class: Senior Secondary School 2

Age: 16 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Normal Form I

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

  1. Define normalization
  2. State the goals of normalization

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 Microsoft access as a relational database model

Students pay attention

STEP 2

EXPLANATION

He explains the meaning of normalization

 

Students pay attention and participates

STEP 3

DEMONSTRATION

He explains the goals of normalization

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

NORMAL FORM

Normalization is the set of guidelines used to optimally design a database to

reduce redundant data. Normalization is a database design technique which

organizes tables in a manner that reduces redundancy and dependency of

data.

A database that is not normalized may include data that is contained in one

or more different tables for no apparent reasons. Normalization is achieved

by applying a number of tests called normal forms to tables.

 

Goals of normalization

The goals of normalization are:

  1. Eliminating data redundancy i.e. duplication of data
  2. To minimize or avoid modification issues
  3. To simplify queries

EVALUATION:    1. Define normalization

  1. State the goals of normalization

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively