List five responsibilities of a database-management system. for each responsibility, explain the problems that would arise if the responsibility were not discharged.

A database management system (DBMS) is defined as a computerized system that enables users to create and maintain a database. It is a general-purpose software system that facilitates the processes of defining, constructing, manipulating, and sharing databases among various users and applications.

Five responsibilities include:

1. Defining a database: involves specifying the data types, structures, and constraints of the data to be stored in the database. The database definition or descriptive information is also stored by the DBMS in the form of a database catalog or dictionary; it is called meta-data.

If a DBMS doesn’t support defining a database; a user might invariably define non-sense as there will be no pre-defined syntax/rule.

2. Constructing the database is the process of storing the data on some storage medium that is controlled by the DBMS.

There will be lack of organization if the DBMS doesn’t hold the responsibility to construct the database.

3. Manipulating a database includes functions such as querying the database to retrieve specific data, updating the data-base to reflect changes in the miniworld, and generating reports from the data.

If the DBMS doesn’t hold the responsibility for manipulating the database, there will be problem arising with user trying to manipulate the database which might be querying the database or searching for information.

4. Sharing a database allows multiple users and programs to access the database simultaneously.

If the DBMS doesn’t hold the responsibility for sharing a database; it will be hard to user to manipulate database sharing within user.

5. Protection includes system protection against hardware or software malfunction (or crashes) and security protection against unauthorized or malicious access.

If the DBMS doesn’t hold the responsibility for Protection; there is very much likely that the database will be exposed to various security threats.

Explanation:

answer(d) sequencing and iteration;