Lesson Notes By Weeks and Term - Senior Secondary 2

Data modelling II

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. Data modelling II

Term: 1st Term

Week: 4

Class: Senior Secondary School 2

Age: 16 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Data Modeling II

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

  1. Explain the advantages and disadvantages of data models

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 the types of data models

Students pay attention

STEP 2

EXPLANATION

He discusses the advantages of data models

 

Students pay attention and participates

STEP 3

DEMONSTRATION

He further discusses the disadvantages of data models

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

Advantages of Data Models

  1. Data Models help us in representing data accurately.
  2. It helps us in finding the missing data and also in minimizing Data Redundancy.
  3. Data Model provides data security in a better way.
  4. The data model should be detailed enough to be used for building the physical database.
  5. The information in the data model can be used for defining the relationship between tables, primary and foreign keys, and stored procedures.

 

Disadvantages of Data Models

  1. In the case of a vast database, sometimes it becomes difficult to understand the data model.
  2. You must have the proper knowledge of SQL to use physical models.
  3. Even smaller changes made in structure require modification in the entire application.
  4. There is no set data manipulation language in DBMS.
  5. To develop Data model one should know physical data stored characteristics.

.

EVALUATION:    1. Discuss the advantages and disadvantages of data modeling

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively