what is Database Management System (DBMS) ?

Database Management System (DBMS)

A database management system (DBMS) is system software for creating and managing databases.

The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.

A DBMS makes it possible for end users to create, read, update and delete data in a database.

The DBMS essentially serves as an interface between the database and end users or application programs ensuring that data is consistently organized and remains easily accessible.

We often mistakenly say our database is Oracle, MySQL, SQL Server, MongoDB,. But, they aren’t databases, they are database management systems (DBMS).

The DBMS is the software that would be installed on your personal computer or on a server, then you would use it to manage one or more database.

The database has your actual data and the rules about that data, while the DBMS is the program that surrounds and manages your actual data, and it enforces the rules you specified on your data. The rules for example could be the type of the data, like integer or string, or the relationship between them.