ADVANTAGES OF DBMS:
• 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.