Question

What is DBMS? Explain the advantages of DBMS.​

Answer 1

Answer:

A Database Management System (DBMS) is defined as the software system that allows users to define, create, maintain and control access to the database.

Advantages :-

• DBMS makes it possible for end users to create, read, update and delete data in database.
• It is a layer between programs and data.

Thanks.....

Answer 2

answer 1=

A Database Management System (DBMS) is defined as the software system that allows users to define, create, maintain and control access to the database. DBMS makes it possible for end users to create, read, update and delete data in database. It is a layer between programs and data.

2nd answer

Compared to the File Based Data Management System, Database Management System has many advantages. Some of these advantages are given below −

Reducing Data Redundancy

The file based data management systems contained multiple files that were stored in many different locations in a system or even across multiple systems. Because of this, there were sometimes multiple copies of the same file which lead to data redundancy. 

This is prevented in a database as there is a single database and any change in it is reflected immediately. Because of this, there is no chance of encountering duplicate data.

Sharing of Data

In a database, the users of the database can share the data among themselves. There are various levels of authorisation to access the data, and consequently the data can only be shared based on the correct authorisation protocols being followed. 

Many remote users can also access the database simultaneously and share the data between themselves.

Data Integrity

Data integrity means that the data is accurate and consistent in the database. Data Integrity is very important as there are multiple databases in a DBMS. All of these databases contain data that is visible to multiple users. So it is necessary to ensure that the data is correct and consistent in all the databases and for all the users.