**ADVANTAGES OF DBMS**
1. Improved availability: One of the principle advantages of a DBMS is that the same information can be made
available to different users.
2. Minimized redundancy: The data in a DBMS is more concise because, as a general rule, the information in
it appears just once. This reduces data redundancy, or in other words, the need to repeat the same data over
and over again. Minimizing redundancy can therefore significantly reduce the cost of storing information on hard
drives and other storage devices. In contrast, data fields are commonly repeated in multiple files when a file
management system is used.
2. Accuracy: Accurate, consistent, and up-to-date data is a sign of data integrity. DBMSs foster data integrity
because updates and changes to the data only have to be made in one place. The chances of making a mistake
are higher if you are required to change the same data in several different places than if you only have to make
the change in one place.
3. Program and file consistency: Using a database management system, file formats and system programs
are standardized. This makes the data files easier to maintain because the same rules and guidelines apply
across all types of data. The level of consistency across files and programs also makes it easier to manage data
when multiple programmers are involved.
4. User-friendly: Data is easier to access and manipulate with a DBMS than without it. In most cases, DBMSs
also reduce the reliance of individual users on computer specialists to meet their data needs.
5. Improved security: As stated earlier, DBMSs allow multiple users to access the same data resources. This
capability is generally viewed as a benefit, but there are potential risks for the organization. Some sources of
information should be protected or secured and only viewed by select individuals. Through the use of passwords,
database management systems can be used to restrict data access to only those who should see it.