OBJECTIVE OF DATABASE

  • Minimization of unnecessary data or minimization of redundant data.

Data redundancy is the duplication of the same data at more than one storage place. This redundancy has to be eliminated by adding the data in one place. The table in the database should always have a primary key that would be a unique id. This will control redundancy and improve system performance.

  • Consistency

Inconsistency means when we query for the same data, that is placed on two different places, then the result will not same. Consistency of data has to be achieved through controlling the unnecessary data.

  • Sharing of data

The objective/aim of the database is to satisfy the data requirement of the various new applications without the need of having separate data for each application.

  • Flexibility

Another objective of the database should be flexible enough. This is needed to meet future specifications. In the future, requirements can be changed so the database should be able to meet them. So, it should make the application developments, cheaper, faster, and flexible.

  • Data independence

One of the most important objectives of the database is database is to eliminate the need to rewrite the application program in case of hardware. The database should adapt/meet the new setup without rewriting programs.

  • Accuracy

The accuracy of the database ensures that the quality and content of data remains content.

  • Privacy and security

Privacy means when, how, and to what part os data should be given to users. The database is costly products so, their security is very important.

It also suggests that incorrect information cannot be stored in the database.