MS Access

Database Management System (DBMS)

A database management system (DBMS) is a collection of programs that are used to create, maintain and access database in a convenient and efficient manner. DBMS uses database manager software to control the overall structure of a database. DBMS is normally used by different purposes.

Objective of Database Management System

Some important objectives of database management system are as follows:

  1. Shareability
  2. Availability
  3. Evolvability
  4. Database Integrity

1. Shareability:

An ability to share data is a fundamental objective of database management system. Shareability means that data is shared by different people at the same time. Data is stored at central place. Different users can access this data from different location. It reduce storage cost and provides data consistency.

2. Availability:

Availability means that the users must be able to access data to access data and DBMS easily. The data should be available when and where it is required.

3. Evolvability:

Evolvability means that DBMS should provide the facility to change the database due to increase in user requirements or change in the technology. The change in database may occur in two ways. It may change by contents or by structure. For Example, the structure of the database may be changed if the operation of an organization is expanded.

4. Database Integrity:

Database integrity ensures that data entered in the database is accurate and consistent. Database is normally shared among different users. some measures must be maintained to ensure database integrity.

8 Comments

Leave a Reply

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

Back to top button