Skip to content

Role of Database Administration in Nigeria – SS2 Data Processing Lesson Note (Second Term)

Lesson note at a glance

Class
SS2
Subject
Data Processing
Term
Second Term
Reading time
4 min
Start of this note, 3 of 5
Take this term’s notes offline
Reading here is free. Download all 5 SS2 Data Processing Second term notes as PDF to print and Word to edit.
Download all three terms, ₦2,000
Instant download. Secure payment by Paystack. Card, bank transfer, USSD or OPay. Payment stuck? WhatsApp us.

A database administrator (DBA) is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organisation.

Advertisement
  • Strategy: designs and develops database strategies for the organisation.
  • Monitoring: watches the system and improves database performance and capacity.
  • Planning: plans for future expansion requirements.
  • Security: may also plan, coordinate and implement measures to safeguard the database.

Behavioural objectives

By the end of the lesson, students should be able to:

  1. define a database administrator;
  2. state the main duties of a database administrator;
  3. explain how a database administrator protects and controls access to a database;
  4. describe the part a database administrator plays in storage, backup and recovery;
  5. explain why database administrators are needed in Nigerian organisations.

What is a database and why does it need an administrator?

A database is an organised collection of related data stored so that it can be easily accessed, managed and updated.

  • DBMS: a database management system is the software used to create and manage a database, for example MySQL, Microsoft Access, Oracle and Microsoft SQL Server.
  • Need for an administrator: a large database holds important records that must stay correct, safe and available.
  • Role of the DBA: the DBA looks after the database and the DBMS so that users can work without problems.

What are the responsibilities of a database administrator?

A database administrator’s responsibilities can include the tasks below, grouped by area of work.

Installation and structure

  • Installing and upgrading: sets up and upgrades the database server and application tools.
  • Modifying structure: changes the database structure, as necessary, from information given by application developers.
  • Licences: ensures compliance with database vendor licence agreements.

Storage

  • Allocating storage: allocates system storage to the database.
  • Planning storage: plans future storage requirements for the database system.
  • Archiving: maintains archive data, which is old data kept for later use.

Security and access

  • Enrolling users: registers new users and maintains system security.
  • Access control: controls and monitors user access to the database.
Advertisement

Performance

  • Monitoring and optimising: checks the speed and use of the database and tunes it to work better.

Backup and recovery

  • Planning: plans for backup and recovery of database information.
  • Backing up and restoring: makes copies of the database and restores them when data is lost.

Support and reporting

  • Vendor support: contacts database vendors for technical support.
  • Reports: generates various reports by querying the database as needed.

Why are database administrators needed in Nigeria?

Database administrators are needed in Nigeria because many organisations store large amounts of important records on computers.

  • Banks: keep customer accounts and transaction records accurate and safe.
  • Schools and examination bodies: store student records, scores and registration details.
  • Hospitals: keep patient records available to doctors and nurses.
  • Government agencies: hold records such as staff, tax and identity data.
  • Telecommunication companies: manage subscriber and billing records.
  • Online businesses: keep product, order and customer data.

Who is a DBA compared with other database workers?

A DBA manages the database itself, an application developer builds programs that use it, and an end user only uses the data.

Person Main work Example
Database administrator Installs, secures, monitors and backs up the database Creates user accounts and restores lost data
Application developer Writes programs and forms that use the database Builds a school result portal
End user Enters, views or searches data with the access given A bank cashier checking an account

How does a database administrator control access to a database?

A database administrator controls access by deciding who may enter the database and what each person may do.

  1. Create a user account for each person who needs the database.
  2. Give each user a username and a password.
  3. Assign privileges, such as read only, add data, edit data or delete data.
  4. Monitor what users do and who logs in.
  5. Remove or block the accounts of people who leave or misuse the system.
Advertisement

How does a database administrator handle backup and recovery?

Backup is making a copy of database data, and recovery is restoring that copy after data is lost or damaged.

  1. Plan how often backups will be made.
  2. Make the backups on schedule.
  3. Store copies in a safe place, away from the main computer.
  4. Test the backups to confirm they can be restored.
  5. Restore the data when there is a fault, theft, virus attack or accidental deletion.
  • Full backup: copies all the data in the database.
  • Incremental backup: copies only the data changed since the last backup.

What qualities should a database administrator have?

A good database administrator needs both technical skills and good character.

  • Technical knowledge: understands a DBMS and a query language such as SQL.
  • Honesty: keeps private data secret.
  • Problem solving: finds and fixes faults quickly.
  • Attention to detail: notices small errors in data and settings.
  • Communication: works well with developers, managers and vendors.

Evaluation

  1. Who is a database administrator?
  2. List five tasks that a database administrator performs.
  3. How does a database administrator control access to a database?
  4. Why must a database administrator plan for backup and recovery?
  5. Name two Nigerian organisations that need a database administrator and say why.

Assignment

List and explain any six responsibilities of a database administrator.

This term's Data Processing topics

SS2 Second Term · 5 topics

  1. Relational Models II
  2. Data Security
  3. Role of Database Administration in Nigeria
  4. File Organisation
  5. Presentation Packages
Advertisement

Lesson Notes for Other Classes

Print it or edit it in Word

Every note is free to read online. A PDF or Word copy of one subject costs ₦1,000 for one term, or ₦2,000 for all three terms.

Sign in first, then choose your class and subject at checkout.