- 10 Marks
Question
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)
Answer
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:
- Data Integrity: Ensures accuracy and consistency of data over its lifecycle.
- Data Security: Protects data from unauthorized access or breaches.
- Data Sharing: Allows multiple users to access data concurrently.
- 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:
- Data Storage: Efficient storage and retrieval of large amounts of data.
- Query Processing: Allows users to perform complex queries to retrieve specific information.
- Backup and Recovery: Ensures that data can be restored in case of loss or corruption.
- Data Security Management: Implements user access controls to safeguard sensitive information
- Tags: Database Management
- Level: Level 1
- Topic: Information Systems
- Series: NOV 2023
- Uploader: Theophilus