DBMS is a software that stores and retrieves user’s data while considering appropriate measures. It is a software used to manage the database. DBMS is a collection of programs which enables its users to access databases, manipulate data, reporting and representation of data.

Eg: MYSQL and Oracle are very popular databases used in different applications.

Task of DBMS

A database is a collection of interrelated data which is used to retrieve, insert and delete data efficiently.

• Data definition
• Data updation
• Data retrieval
• User administration

Characteristics of DBMS

• It uses digital repository
• It contains ACID properties(Atomicity, Consistency, Isolation, Durability)
• Reduces complexity relationship between the data

Advantages of DBMS

• Controls Data redundancy
• Data sharing
• Reduce time
• Easy maintenance
• Provides backup

Disadvantages of DBMS

• It occupies a large space of disk
• It has a higher impact on failure
• It requires high speed of data processor and large memory size to run DBMS
• Database creates complexity. That is; Additional complexity and requirements