Lesson Notes By Weeks and Term - Senior Secondary 3

Database security III

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Lesson Notes By Weeks and Term
  3. Senior Secondary 3
  4. Database security III

Term: 1st Term

Week: 10

Class: Senior Secondary School 3

Age: 17 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Database security III

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

  1. Explain the meaning of database administrator
  2. Discuss the roles of a database administrator in data security

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 importance of data security

Students pay attention

STEP 2

EXPLANATION

He explains the meaning of database administrator

 

Students pay attention and participates

STEP 3

DEMONSTRATION

He discusses the roles of a database administrator in data security

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

THE ROLE OF DATABASE ADMINISTRATOR IN DATA SECURITY

A database administrator (DB) is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization. The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate an implement security measures to safeguard the database.

 

A database administrator’s responsibilities can include the following tasks:

  1. Installing and upgrading the database server and application tools.
  2. Allocating system storage and planning future storage requirements for the database system
  3. Modifying the database structure, as necessary, from information given by application developers.
  4. Enrolling users and maintaining system security.
  5. Ensuring compliance with database vendor license agreement.
  6. Controlling and monitoring user access to the database.
  7. Monitoring and optimizing the performance of the database.
  8. Planning for backup and recovery of database information.
  9. Maintaining archive data.
  10. Backing and restoring databases.
  11. Contacting database vendor for technical support.
  12. Generating various reports by querying database as per need.

 

EVALUATION:    1. Explain the meaning of database administrator

  1. Enumerate the roles of a database administrator in                    data security

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively