Advantage And disadvantage of DBMS

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.

1 thought on “Advantage And disadvantage of DBMS”

  1. Hi there would you mind letting me know which web host you’re utilizing? I’ve loaded your blog in 3 different internet browsers and I must say this blog loads a lot faster then most. Can you recommend a good hosting provider at a fair price? Thanks a lot, I appreciate it!

Leave a Reply

Your email address will not be published. Required fields are marked *