DBMS – The Coder Net

Database Management System

You must have listened to DBMS, its full name is Database Management System. It is known by the name that it manages the entire database. Database management systems do all the work from forming, managing and removing data. Software that can create, maintain, control, remove and update data.

Through DBMS both users and programmers can handle their data, i.e. both can create, manage and refresh the data. It has various benefits, about which it is very important for you to know. Let us know what DBMS is and what happens in it, in detail.

Here we will know about DBMS in easy language. And we will know about its characteristics. So let’s start: –

Introduction:

Database Management System consists of 3 words. A detailed explanation of these three words is given below.

Data:

Data is available to you in many ways like name, age, and address of a person. Data changes in different contexts like data related to a person are his name, age, and address. Similarly, data for a company can be information about its sales, purchase, and employees.

If said in simple words, data is information that represents an entity and its attributes. The entity is the element about which data occurs. The examples above are individual and company entities. The data about the entity such as name, age, and address are called attributes.

We have many types of data. Sometimes data is in words such as one’s name and sometimes data is in numbers such as one’s age.

Database:

A database is a group of similar data. By related data here means that data that has some relation.

Management:

Here the term management is given in the context of data. Here the word management means managing data. Let us know why data needs to be managed.

1. If you manage the data, it will be easily found by searching.

2. Operations (retrieving, updating, modifying) can be performed easily.

3. Data will not be lost and will always be available.

4. Data will not be corrupted.

5. Data can be secured.

System:

The system here means software. A software that is used to manage data.

also read: What is Programming Language?

What is DBMS:

A database is a group of related data. The data set is the facts and figures that are prepared to generate information.

Most data describe recordable facts. Data helps to produce information that is based on facts. for example. If we have marks of one class then we can decide who among them are toppers and who are medium marks.

Components of Database Management System:

1. Tables

In DBMS each data is stored in tables. Data collection, filtering, editing, retrieving, etc. are all done on the tables. The tables are made up of rows and columns that store all the data inside.