+2 votes
in Database Management Systems by (user.guest)

1 Answer

0 votes
by (user.guest)
Best answer


• Control of data redundancy

DBMS integrates all the files such that same data is not stored .Though it does not completely remove redundancy but it controls the redundancy inheritance.

• Data Independence

Application programs should not ideally be exposed to details of data representation and storage. Therefore DBMS provides an abstract view of the data and hides all such details.

• Efficient Data Access

DBMS utilizes a variety of sophisticated techniques to store and retrieve data in an efficient manner. Data can be easily accessed by using DBMS.

• Data Integrity and Security

If data is always accessed through DBMS then DBMS can enforce integrity constraints. For example, before inserting the salary information of an employee, DBMS can check that the department budget is not exceeded. Thereby it ensures security of the data.

• Concurrent Access and Recovery

A DBMS schedules concurrent access to data in such a way that users think that the data is being accessed by only one user at a time. It protects the users from the effects of system failures.

Welcome to CPEN Talk
Solution-oriented students of computer engineering on one platform to get you that