What are the advantages of DBMS Approach in managing data?

Advantages of the Database Approach

· Data Independence

The data is held in such a way that changes to the structure of the database do not effect any of the programs used to access the data.

· Consistency of Data

Each item of data is held only once therefore no danger of item being updated on one system and not on another.

· Control Over Redundancy

In a non-database system, the same information may be held on several files. This wastes space and makes updating more time-consuming. A database system minimizes these effects.

Integrity of Data

The DBMS provides users with the ability to specify constraints on data such as making a field entry essential or using a validation routine.

Greater Security of Data

The DBMS can ensure only authorized users are allowed access to the data.

Centralized Control of Data

The Database Administrator will control who has access to what and will structure the database with the needs of the

More Information Available to Users

Users have access to a wider range of data that was previously held in separate departments andsometimes on incompatible systems.

Increased Productivity

The DBMS provides an easy to use query language that allows users to get immediate response from their queries rather than having to use a specialist "programmer" to write queries for them. whole department in mind