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
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.
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.
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.
DBMS is equipped with query language which makes it easy to manipulate data.
Different user accounts may have different access permissions using this the user can easily secure their data by unauthorized users.
DBMS supports transactions thus helping the user to maintain the integrity of the database.