In this article functions of DBMS we give the information about it is used to store customer information, payment, account activities, deposit and loan information in the bank.
Functions of DBMS:-
- Data Redundancy
Every application has its own personal files in the file system and in such a situation, duplicate files of the same data are created at many places. In DBMS, files of the same type are kept at one place, that is, they are not repeated, which reduces the redundancy of data.
- Sharing Of Data
Data is shared by the authorized users of the organization. In this, the data administrator controls the data and gives rights to the user to access the data.
- Data Consistency
Through DBMS, the same type of data can be prevented from being stored repeatedly in the database.
- Integration of Data
In DBMS, all the data is in tables and there is more than one table in a database. Relationships can be created between all these tables making it easy to retrieve and update data.
- Data Security
In DBMS, the data is completely controlled by the data administrator. In this, the administrator ensures which user is to be given data and how much data is to be given. The database administrator controls which part of the database the user is allowed to access and which part is not. This increases the security of the database and the data does not fall into wrong hands.
You all know that computer is a kind of machine and it can malfunction at any time and hardware or software failure can happen at any time, in such a situation data can be destroyed. Through DBMS you can easily recover data in such conditions.
In simple words, “DBMS is a software that acts as an interface between end users and the database. “With its help, the user can store the data properly in the database and can easily access the data whenever he wants.”
The database management systems used today are:- DBase, FoxPro, IMS, Oracle, MySQL, SQL, and DB2 etc.
Functions of DBMS:-
- It is used to store customer information, payment, account activities, deposit and loan information in the bank.
- It is used for ticket booking and reservation in airlines.
- In colleges and schools, it is used to store student information, course registration, and teacher information.
- In telecommunication, DBMS is used to store call records, bill and balance information.
- In Finance, it is used to store information about stock, sales, and purchases.
- In Sales, it is used to store customer, product and sales information.
- In manufacturing, it is used for supply chain management and tracking the product.
- In HR management, it is used to store information about employees, salary, payroll and paycheck etc.
Advantages of DBMS
There are many benefits of database management system which are given below:-
1:- In DBMS, data can be searched easily.
2:- In this the data can be retrieved easily.
3:- In this the user can manage the data in a better way.
4:- Security is very good in database management system. No hacker can hack it easily. Apart from this, the risk of getting virus is also very less.
5:- Duplicate data cannot be stored in it.
6:- In this, one user can easily share data with another user.
7:- In this, the privacy and integrity of the user is maintained.
8:- In this, the user can take backup of data anytime as per his requirement.
9:- Working in DBMS is very easy. In this we can easily do any work.
10:- Large amount of data can be stored in it.
11:- In this many users can work at the same time.
12:- It is user friendly.
Disadvantages of DBMS
Its disadvantages are given below:-
1:- The cost of hardware and software is very high.
2:- Some database management systems are difficult to work with. Therefore, it is necessary to give training to the users.
3:- Sometimes due to power failure the data gets automatically deleted.
4:- Its design is quite complex.
5:- In this, many users access the same program at the same time due to which sometimes some data is lost.
Components of DBMS
A database management system consists of the following components:-
Hardware includes our computer system which is used to store and access our database. This includes physical electronic devices such as computers, I/O channels, storage devices etc. Hard disk is mostly used to store data in computer system.
This is the most important component of DBMS. It is a group of programs that are used to control and manage the entire database. This includes DBMS software, operating system, and application programs.
DBMS software is located between the database and the users. It provides a very easy interface through which data is stored, updated, and retrieved in the database.
Data is a main important component of DBMS. DBMS stores, processes and accesses data. Old data, operational data and metadata are stored in the database.
There are many users in it who access the data as per their needs. The capabilities and needs of each user are different. In this the users are as follows:-
- Database administrator
- Database designers
- Application programmers
Procedures include rules and instructions for using the database management system. It tell how the database is to be used in the system. Such as:- installing and setting up the DBMS, logging into the database, logging out, taking backup of the database, and handling the database etc.