Advantage and disadvantage of database

ADVANTAGE OF DATABASE

  • REDUNDANCY CAN BE REDUCED
Data redundancy is the duplication of some data at more than one storage place. And database avoided this type of data.

  • INCONSISTENCY CAN BE AVOIDED

Data duplication may show inconsistency. If the data is stored at two locations, then the user may forget to update another location. So, if the redundancy is removed, the chances of having inconsistent data are also removed.

  • DATA CAN BE SHARED

This means various users can use some data in the database.

  • SECURITY CAN BE APPLY/ENFORCED

The database is very costly so, security is very important in the database.

  • INTEGRITY CAN BE MAINTAINED

Integrity means that the database in the database is accurate. It also means that incorrect information can't be stored in the database.

  • FASTER DEVELOPMENT OF NEW APPLICATION

When a new application is proposed, likely, the data required for it is already stored in the database. So, the development time is reduced for the new application.

DISADVANTAGE OF DATABASE

  • All the complete data in a single database. If the database is damaged due to database electric failure valuable data is lost forever.
  • The data structure may be become more complex because of the centralized database supporting many applications in an organization.