So, DBMS is necessary to keep track of all the book records, issue dates, name of the books, author and maintain the records.īanking − We are doing a lot of transactions daily without directly going to the banks. Library Management System − There will be so many numbers of books in the library and it is very hard to keep a record of all the books in a register or a copy. Railway Reservation System − It is used to keep record of booking of tickets, departure of the train and the status of arrival and give updates to the passengers with the help of a database. The different applications of DBMS are as follows − For example, the fund transfer from one account to another may be incomplete.ĭatabase system offer so many solutions to all these problemsĭata independence and efficient access of data.Ĭoncurrent access and recovery from crashes. These are mentioned below −ĭata redundancy and inconsistency: Different file formats, duplication of information in different files.ĭifficulty in accessing data: To carry out new task we need to write a new program.ĭata Isolation − Different files and formats.Ītomicity of updates − Failures leave the database in an inconsistent state. There are so many drawbacks in using the file system. Previously, the database applications were built directly on top of the file system. The diagram given below explains the process as to how the transformation of data to information to knowledge to action happens respectively in the DBMS − The purpose of DBMS is to transform the following − It is a collection of programs used for managing data and simultaneously it supports different types of users to create, manage, retrieve, update and store information.

The Database Management System (DBMS) is defined as a software system that allows the user to define, create and maintain the database and provide control access to the data.

Javatpoint library management system