DBMS

Q. Explain DBMS with suitable example.
Ans.:- A database management system is a computer software application that interacts with end users,other applications and the database itself to capture and analyze data.It is designed to assist in maintaining and utilising large collection of data and the need for such system as to retrieve,manipulate,store and produce information as per query.A general purpose DBMS allows the definition,creation,querying,update and administration of databases.It is a system software for creating and managing databases.

The DBMS also manages incoming data,organises it and provides ways for the data to be modified or extracted by users or other programs.DBMS also provides protection and security to the databases.It also maintains data consistency in case of multiple users.Database management systems are categorised according to their data structures or types.It also provide many views of a single database schema.When a DBMS is used,systems can be modified much more easily when business requirement changes.

A DBMS uses more memory and CPU than a simple file storage system.Different types of DBMS requires different types and levels of system resources.There are many different types of database management systems ranging from small systems that run on personal computers to huge systems that run on mainframes.

Some examples of DBMS are MySQL,Microsoft Access,SQL Server,Oracle,RDBMS,Foxpro etc.
Let us consider an example of student record keeping system database project in which there is a student file that contains the information about student,a stream file,a fee file,scholarship etc.This all is done through the DBMS.