Database

A database is a collection of inter-related data that helps in efficient operations like insertion, deletion, and retrieval of data. Data is the collection of facts and figures that are processed to provide information.

 

Database Management System

The software that is used to manage the database is called DBMS. Example: Oracle, MySql etc. It stores data in a way to make it easier to retrieve, manipulate, and produce information.

 

Characteristics of DBMS

 

Data Storage

In DBMS the data is stored in the tables. The structure of these tables is called schema. The schema provides information about the different attributes of the name of the table, data type etc. DBMS also represent the relationship among the related tables.

 

Reduced Redundancy

The significant characteristic of DBMS is that it reduces the redundancy. Redundancy refers to the unnecessary repetition or duplication of data. Normalization concept is used by DBMS to reduce the data redundancy. It breaks the table into smaller tables thus minimizing the redundancy.

 

Data Consistency

DBMS provides a better level of data consistency. Consistency is a state where every relation in a database remains constant. The result of any manipulation or updating should be reflected.

 

Query Language

DBMS is equipped with query language which makes it easy to manipulate data.

 

Security

Different user accounts may have different access permissions using this the user can easily secure their data by unauthorized users.

 

Transaction Support

DBMS supports transactions thus helping the user to maintain the integrity of the database.