Question

A general-purpose database management system (DBMS) has 5 basic responsibilities:

• Interaction with the file management system

• Integrity enforcement

• Security enforcement

• Backup and Recovery

• Concurrency control

For each responsibility, explain the problems that would arise if the DBMS did not execute these responsibilities. Be descriptive and give examples where appropriate.

Answer 1

Hello, Student hope you are doing all good n well in Lockdown, here is answer of your question .

DBMS has 5 basic responsibilities:

1. Interaction with the file management system
2. Integrity enforcement
3. Security enforcement
4. Backup and Recovery
5. Concurrency control

If these all five responsibilities were not executed by DBMS then the following problems will be occur respectivity: -

1.Interaction with the file management system:-

DBMS can not be possible without this responsibility, if there is no file management system or intraction then nothing can happen or can retrieved which is stored in files.

Basically we can not fetch any data which is stored in files because without intraction to that file this is not possible.

Example : - We can not read or write into a file.

2.Integrity enforcement :-

Integrity is set of rules, and used to maintain quality of data.

Without Integrity enforcement DBMS flow can not be possible because rules are everywhere to control everything around us without this DBMS flow can go out of control.

Examples:- Account balance can go below to minimum allowed, driver can drive more hours than allowed by law etc.

3. Security enforcement:

if the DBMS did not execute this responsibility than anyone can access to database and leak every data which is stored in database basically known as Unauthorized access.

Example: - You can get your classmates marks which is stored in your college database by Unauthorized access.

4.Backup and Recovery:-

if the DBMS did not execute this responsibility then there is huge loss to any organization because Data could be lost permanently in case of any type of failure, Which leads to loss of whole data which is used within a organization.

5. Concurrency control:-

In DBMS there is a situation when multiple transactions can be executed simultaneously, It is very important to control concurrency of transactions, if the DBMS did not execute this responsibility then users may lost their transactions and wrong information may be shown to users which will voilate the rules and violate despite proper integrity enforcement in each transaction.

Example : - Wrong bank balance might be shown or reflected beacuse of simultaneously transcations.

Please upvote or hit that like,thumbs-up button, it really motivates me<3.

Thank you!!

Have a nice day:)