What is Database Management System Types and uses of DBMS

What is Database Management System Types and uses of DBMS.

Hello friends, what’s a database? what’s Database Management? Today we’ll study the database during this article. What are DBMS? sorts of management Systems? Usage of DBMS? then on. 

All the questions associated with DBMS, you’ll get the answers of all of them during this post today. Websites, software, games, videos, files, data are everywhere. But have you ever ever wondered where of these data are kept. So let me tell you that this is often possible only with the assistance of database.

What is database management system

what’s data? (What is Data?)

Before understanding a database, we’d like to understand what data is. Data may be a small a part of any information and raw facts. Data is raw facts that themselves haven’t any meaning but have value. Any number, text, letters, image, audio, video, etc. Data are often . When of these data are organized during a form, then these information are divided.

sorts of data? (Types of Data?)

allow us to understand what quite data are there? we will divide the info to be stored within the computer into the subsequent classes:

 1 Numerical data.

It consists of numbers from 0 to 9 (Total 10). Arithmetic functions are often performed on numerical data. the amount of scholars during a class or their score in an exam is numerical data.

2 Alphabetic Data.

This data consists of all the letters of the alphabet. for instance , there are letters of English alphabet (A to Z) and letters of the Hindi alphabet (A to Z) etc. The address or name of scholars of a category is letter data.

 3 Alpha numeric data.

This data consists of all numbers, alphabet, special characters and symbols. Arithmetic verbs can’t be used, but they will be compared. for instance , the address letters of scholars of a category are often numeric data.

 4 Sound Data.

Sound data is data during which voice is present. all kinds of files stored during a computer that contain voice are called sound data. like – mp3 file, wav format file, etc.

 5 Graphics Data.

Graphic data includes data stored within the sort of images, images, written images or graphs.

6 Video data.

Video data includes all kinds of moving pictures.

What’s a database? (What is Database?)

A database may be a group of the many data. Those are stored during a systematic manner in one place for a specific purpose. 

the info is organized and stored in one place in order that various information are often obtained from it and that they are often used as per requirement. an equivalent database are often used for quite one purpose.

Let’s understand the database with an example – MS Excel is employed to make some data. Like we create a table to make a knowledge in MS Excel and make many columns and rows and store the info in it consistent with need. Which makes our work easier. 

Similarly, within the database, the info is stored during a table, which consists of the many different rows and columns, thanks to which it becomes easy to use those data.

What’s management System? (Whats is management System?)

We also call the management System DBMS briefly. If we understand DBMS in simple words, it’s a system during which data is managed. 

Database may be a software program in mind, speculatively employing a computer to arrange (edit) digital data, make changes, update it, share data, delete old data and store new data. Does the work of

Database management system provides many authorized users the power to share data and knowledge for various purposes. 

management system may be a system of using computer to store facts in one place and use them by authorized users. It specifies the info types and structures for the shop data within the database. 

Characteristics of DBMS.

Storing data.

The DBMS i.e. management system is capable of storing any sort of data. In management system, not only name and address data are often stored but also any sort of data present within the actual world.

 Backup and Recovery.

Problems like database malfunctions can occur. In such a situation, if the info couldn’t be recovered, then there would definitely be loss. Therefore the database has the feature of backup and recovery.

 Low data redundancy.

The management system follows the principles for storing any sort of data during a normal way, which reduces the likelihood of knowledge redundancy, ie duplication of knowledge .

Data Integrity and Security.

management enhances the standard and reliability of knowledge before it’s stored within the system. the safety of DBMS should be very high level so it prevents Unauthorized Access within the database and makes it safer .

Data independence.

Each value of the info stored within the management system must be independent of every other and self-sufficient in order that any program is in a position to freely use any a part of the info .

Privacy of knowledge.

to take care of the confidentiality of knowledge within the database, it’s determined who can view or modify which data to which extent. this is often how privacy of any important or personal data is ensured.

Data inconsistency
Data Inconsistency is that different values of an equivalent factor at different places within the database are called. 

this might yield two different results on an equivalent subject. There should be no data inconsistency in any database, so it can eliminate Data Inconsistency by stopping Data Redundancy within the database.

 sorts of DBMS.

1 electronic database.

In this, the info is stored as a set of tables. These tables contain Rows and Columns. It makes it very easy to seek out data and it’s also called relational because the info stored in it’s some relation between all the tables.

2 Network Database.

during this sort of database model, data is stored as a set of records. These records are interlinked by links. Where does this sort of relationship attend many relationships? It also can have quite one parent of a toddler network.

3 Hierarchical Database.

 during this also the info is stored as a set of records, but all the records are almost like the tree, so all the records are linked together during a tree like structure. 

it’s the oldest and popular data model during which data manipulation language software is employed . There are often many children of a parent but a toddler has just one parent, this sort of relationship is named one to several relationship.

4 Object Oriented Database.

 Data during a database is stored as an object during this sort of model. There are often differing types of relationships between two or more objects. Creating this sort of database requires object oriented programing language .

What are management system software?

 ☆ MySQL
 ☆ SQLite
 ☆ Microsoft SQL Server
 ☆ Oracle
 ☆ Microsoft Access
 ☆ dBASE
 ☆ IBM DB2
 ☆ PostgreSQL
 ☆ Foxpro
 ☆ MariaDB
 ☆ NoSQL

Where are management systems used?

 ☆ Banking
 ☆ Airlines
 ☆ Telecommunication
 ☆ Railway reservation system
 ☆ Library management system
 ☆ School college university
 ☆ Social media sites
 ☆ Military
 ☆ Manufacturing
 ☆ Online shopping
 ☆ HR management, Etc.

Components of management system

 1 Data: 

First component of management system (DBMS) is data. Which is capable of storing any sort of data within the database. Like – number, character, date, name, address, etc.

 2 Hardware: 

Hardware is that the second component of management system. this suggests that each one sorts of hardware devices also are required to store data within the database. like – computer, memory device , input output device, etc.

 3 User: 

User is that the third component of management system. it’s necessary to possess a user to store the info within the database, because it’s impossible to store any data without the user. Because the info where it’s stored may be a machine, the saw machines don’t work themselves. There are often three sorts of users within the user.

 i Database Administrator.

 ii Application Programmer.

 iii user.

 Advantages of DBMS.

 ☆ Reduces data redundancy.
 ☆ DBMS supports Multi User Environment.
 ☆ Keeping data secure within the database is extremely easy.
 ☆ Database sharing is straightforward between Authorized Users.
 ☆ Secures data from Unauthorized Users.
 ☆ there’s confidentiality of knowledge in it.
 ☆ there’s no data consistency within the database.
 ☆ It also takes a really short time in application development.

 Disadvantages of DBMS.

 ☆ Many stars like Database Administrator, Programmer, Operator are required. And it’s necessary to offer them an honest training for this.
 ☆ DBMS may be a very large software, so a high configuration system is required to run it correctly which may be very costly.
 ☆ In DBMS all data is stored within the same database hence the likelihood of Database Failure is high.
 ☆ Hardware and software are far more expensive. 

In last

So friends, now you’ve got learned what the database is? what’s management ? What are DBMS? sorts of Database Management Systems? Usage of DBMS? then on. 

I hope you liked the post. And you’ve got understood all the items I even have said. If you continue to have any question, you’ll ask us by commenting. If you liked the post, please share this post with all of your friends on social media.

Leave a Comment

Your email address will not be published. Required fields are marked *

Share via
Copy link
Powered by Social Snap