# Lesson Notes By Weeks and Term - Senior Secondary 3

Data models II

Term: 1st Term

Week: 2

Class: Senior Secondary School 3

Age: 17 years

Duration: 40 minutes of 2 periods each

Date:

Subject:      Data Processing

Topic:-       Data Models II

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

1. Discuss the three levels of abstraction in data modelling

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 concept of data modeling Students pay attention STEP 2 EXPLANATION He explains the conceptual and logical level of abstraction Students pay attention and participates STEP 3 DEMONSTRATION He further explains the physical level of abstraction 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

LEVELS OF ABSTRACTION IN DATA MODELING

Data modeling typically involves several levels of abstraction, including:

1. Conceptual level: The conceptual level involves defining the high-level entities and relationships in the data model, often using diagrams or other visual representations.
2. Logical level: The logical level involves defining the relationships and constraints between the data objects in more detail, often using data modeling languages such as SQL or ER diagrams.
3. Physical level: The physical level involves defining the specific details of how the data will be stored, including data types, indexes, and other technical details.

EVALUATION:    1. Explain the three levels of data abstraction

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively