Function of DBMS

Function of DBMS

DBMS

A Database Management System perform the following important function to ensure the integrity and consistency of data in the database

Reduce data redundancy

data redundancy means duplication of data. A DBMS helps to remove duplicate data.

Facilitates sharing of data

Different users can access and use the same database.

Control data inconsistency

A change in any one file is automatically updated in all the related files.

Enforce standard

In a DBMS, certain standards can be applied in data representation, such as the naming, structure and format of data.

Ensure data security

The access to any record can be protected in a DBMS. The file can be access only by those who are authorised to do so

Maintain integrity

A DBMS maintains integrity by keeping some constraints when data is entered

DataBase Object

Microsoft Access

Alternative

How to install open office base?

• Go to urlt: openoffice.org