Lesson Notes By Weeks and Term - Senior Secondary 2
Normal form I
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
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:
EVALUATION: 1. Define normalization
CLASSWORK: As in evaluation
CONCLUSION: The teacher commends the students positively