Database and database management system are TWO terms that are very paramount in the management of data.

You are required to:
i. Define Database Management System. (2 Marks)
ii. List FOUR characteristics of a database. (4 Marks)
iii. Enumerate FOUR facilities provided by a Database Management System. (4 Marks)

i. Definition of Database Management System (DBMS):
A Database Management System (DBMS) is software that allows users to store, retrieve, and manage data efficiently in a structured and organized manner. It provides tools for data storage, manipulation, and security.

ii. Characteristics of a Database:

  1. Data Integrity: Ensures accuracy and consistency of data over its lifecycle.
  2. Data Security: Protects data from unauthorized access or breaches.
  3. Data Sharing: Allows multiple users to access data concurrently.
  4. Data Independence: Data is separated from the applications that use it, allowing changes without affecting the system’s functioning.

iii. Facilities Provided by a DBMS:

  1. Data Storage: Efficient storage and retrieval of large amounts of data.
  2. Query Processing: Allows users to perform complex queries to retrieve specific information.
  3. Backup and Recovery: Ensures that data can be restored in case of loss or corruption.
  4. Data Security Management: Implements user access controls to safeguard sensitive information
online
Knowsia AI Assistant

Conversations

Knowsia AI Assistant