What is DBMS? Application,Types, Example,Advantages, Disadvantages

What is a Database?

A database is a collection of related data which represents some aspect of the real world. A database system is designed to be built and populated with data for a certain task.

What is DBMS?

Database Management System (DBMS) is a software for storing and retrieving users' data while considering appropriate security measures. It consists of a group of programs which manipulate the database. The DBMS accepts the request for data from an application and instructs the operating system to provide the specific data. In large systems, a DBMS helps users and other third-party software to store and retrieve data.

DBMS allows users to create their own databases as per their requirement. The term “DBMS” includes the user of the database and other application programs. It provides an interface between the data and the software application.

In this tutorial, you will learn more about-

• Example of a DBMS
• History of DBMS
• Characteristics of Database Management System
• DBMS vs. Flat File
• Users in a DBMS environment
• Popular DBMS Software
• Application of DBMS
• Types of DBMS
• Advantages of DBMS
• Disadvantage of DBMS
• When not to use a DBMS system?
• Let us see a simple example of a university database. This database is maintaining information concerning students, courses, and grades in a university environment. The database is organized as five files:
  • The STUDENT file stores data of each student
  • The COURSE file stores contain data on each course.
  • The SECTION stores the information about sections in a particular course.
  • The GRADE file stores the grades which students receive in the various sections
  • The TUTOR file contains information about each professor.
  To define a database system:
  • We need to specify the structure of the records of each file by defining the different types of data elements to be stored in each record.
  • We can also use a coding scheme to represent the values of a data item.
  • Basically, your Database will have 5 tables with a foreign key defined amongst the various tables.