In this tutorial, we will learn about what is DBMS and before this, we will learn Database because DBMS is performed on a Database.
What is Database?
A Piece of information which is used to access in future for our personnel and public use.
The database is the collection of the same information which is arranged systematically for future use.
In simple terms, the data of schools, colleges, businesses, etc are collected and form a database for future use.
Also Read: What is Database?
Why do we need a Database?
We need a database to get information about our work when required. In simple terms, when you running a college, school, or a business, then there is a data related employees, students, teachers, and staff then you have to save their information, and this is known as their data and data related to their field is known as a database.
Also Read: Advantages and Disadvantages of Database
What is DBMS?
DBMS stands for Database Management System
It is a process or system which manages the database. In simple terms, DBMS allows the user’s to access the database easily and can update, delete information from the database.
Why we need DBMS?
Actually, DBMS is a need for Database, because without DBMS user’s will have difficulty in accessing the database.
DBMS provides them an environment to access, delete, update the database because the database is physically stored in files and DBMS is the software that provides us a logical view of data which is in the form of a table in a systematic order.
Therefore, DBMS is a tool through which we can perform several actions on data in the database.
Can you tell, Is DBMS software or not?
So, the answer is No- DBMS is not software, because the software is installed on a computer, and DBMS is not installed on a computer. DBMS is a domain like in the software industry there is development, testing teams, in the same way, there is a DBA- Database Admin, who is looks after DBMS.
Some of the examples of DBMS are:
- Oracle
- RDBMS
- SQL Server
- IBM DB2
- Clipper
- Teradata
- MySQL
- FileMaker
- Informix
- Microsoft Access
- Foxpro
- SQLite,..etc
Also, read these topics:
Advantages and Disadvantages of Database