Question

Identify 5 benefits of using a Database management systems

Answer 1

Database management system (DBMS) having many advantages in the software world & as per basic traditional computer approaches.
DBMS compared & create the management of the Database. Here are some effective benefits of using the DBMS for the software
1. Controlling the data redundancy.
2. Integration of data.
3. Sharing of data.
4. Increases the consistency of data.
5. Control over the concurrency of data.

1. Controlling the data redundancy: Each program applications has their own private file in non-database system.
But in this database system, many copies of the duplicate data is created easily & fast with the same time & same data.
data redundancy is stands for the non-duplicacy of the data files & data is only stored in single place with the organized manner.

2. Integration of data: When the retrieval & updating of data can be done easily in the stored table in DBMS.
In this, we can integrate the tables and associate the relationship of data entities with their specified
entities. Integration of data it helps to build the relationships of the tables (constraints & entities).

3. Sharing of data: In this case, the data could be shared easily by the users but it is only for the administrator
which gives the access to the users for sharing the further data. It helps to manage the authorization of
accessed users to share the data within the same time, multiple users can shared the single data with same time.

4. Increases the consistency of data: When the data redundancy is monitored by the users, so they can easily modified the data
& during this the users gets updates instantly. So basically this case manage the data consistency to the authorized users with
the new updates.

5.Control over the concurrency of data: In the computer system, there are two users of data which they can shared the same file
where they suppose to connect with any interface.Overwrite of data in the same table is allowed in this case.
Because of this step we can update the data by the overwritten & performing the different operations in the same table by the two
users. So it helps to improves the accuracy of data for users within the same time on the same panel, which means that
concurrency is controlled over the sharing or updating of data.