☞ Some advantages of using a DBMS are :
1. Reduces Data Redundancy 2. Sharing of Data 3. Data Integrity 4. Data Security 5. Privacy 6. Backup and Recovery 7. Data Consistency 8. Increase Efficiency 9. Increase Validity 10. Increase Accuracy
☞ 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.
☞ In a database, the users of the database can share the data among themselves.
☞ It allows multiple-users to operate the database at the same time, making it more efficient.
☞ Data integrity means that the data is accurate and consistent in the database.
☞ As there is multiple databases, 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.
☞ Only authorised users should be allowed to access the database and their identity should be authenticated using a username and password.
☞ The privacy rule in a database states that only the authorized users can access a database according to its privacy constraints.
☞ DBMS automatically takes care of backup and recovery.
☞ The users don't need to backup data periodically because this is taken care of by the DBMS.
☞ Data Consistency is ensured in a database because there is no data redundancy.
☞ Data Consistency means there should be multiple mismatching copies of the same data
☞ All data appears consistently across the database and must be same for all the users viewing the database.
☞ Since data tables are properly organised, saving, reading and searching data can be carried out efficiently.
☞ Valid data or invalid data being entered can be checked at the data entry stage.
☞ Since data redundancy and inconsistency can be minimised in a database, the data is retrieve accurately from the database.
☞ Following are a few applications where the usage of DBMS has become unavoidable :
1. Railway and Airline Reservation 2. Library Management 3. Banking System 4. Education Sector 5. Social Media Platforms 6. E-Commerce