Lesson Notes By Weeks and Term - Senior Secondary 3

Database management II

Term: 1st Term

Week: 9

Class: Senior Secondary School3

Age: 17 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Computer studies and ICT

Topic:-       Database Management II

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

  1. Explain the meaning of database objects
  2. List the elements in a typical database
  3. Create a database

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 III 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 Database management

Students pay attention

STEP 2

EXPLANATION

He explains what database objects are and explains the meaning of each.

He then lists the elements in a typical database

 

Students pay attention and participates

STEP 3

DEMONSTRATION

He then shows the learners how to create a 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 MANAGEMENT

Database Object

A database object is a data structure used to either store or reference the data. The following are some of the objects in MS Access

  1. Table: this is the most important database object. It consists of rows and columns. It stores records about a particular entity.
  2. Form: this object provides a convenient way to enter and view records in a table
  3. Query: this object enables the user to locate records that match specified criteria.
  4. Report: this object allows you to format, organize and summarize all or a portion of the data in a database

Other database objects are Macro and Module.

Database elements

The elements of a typical database are Tables, fields, records, primary key and characters.

Creating a database

To create a database:

  1. Click BlankDatabase button on the Backstage View window
  2. On the Filename box, type in an appropriate name for the database, then click Create

Note that in giving a name to your database, the name cannot be longer than 255 characters in length and must not contain the following characters:

Forward slash (/), Asterisk (*), Back slash (\), Colon (:), Question mark (?), Quotation mark (“), Pipe symbol (|), Greater than (>) and less than (<) symbols.

EVALUATION:    1. Define database objects. Mention and explain three

  1. List some database elements
  2. List five characters that cannot be used to name a                    database

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively