DBMS advantage is the following.
1.No data redundancy and inconsistency: In many places of the same type of data we duplication, we call Data redundancy. And so much of a kind of data cause data inconsistency. Thereby increasing the storage and cost. But in DBMS we get rid of it.
2. Restricting Unauthorized Access: DBMS uses the database administrator security and unauthorized subsystem to specify account restrictions. DBMS advantage
3. Data Integrity and Security: DBMS takes full care of security and integrity (integrity). It is necessary to satisfy some conditions before inserting any type of value in the database.
The user does not have access to all data in the database. Thereby increasing data integrity.
4.Simple Access: The database can be easily accessed in DBMS. The application programming interface (API) is used to easily access.
Disadvantage of DBMS
After the DBMS benefit, we read its disadvantage, which is as follows: –
1: -The value of DBMS software and hardware is very high.
2: -DBMS’s functionality is very complex.
3: – Its size is very high.
4: – All components of this have to be constantly updated which is very difficult.
5: -If the electric failure or database is corrupted then the database which stores important data in the database can be lost.