Typically database management system is considered as a computerized record keeping system. However, DBMS is a collection of programs, which are used to define, create and maintain database. Basically, database management system is a general-purpose software package whose overall purpose is to maintain information and to make that information available on demand. You can also develop a special purpose DBMS software (in Visual Basic, C++ etc.) to create and maintain database.
There are many functions of general-purpose DBMS software but the main functions are:
- Defining the Structure of Database: which involves defining tables and their relationships, fields and their data types and constraints for data to be stored in the database.
- Populating the Database: which involves to store data into database.
- Manipulating the Database: which involves to retrieves specific data, update data, insert data, and to generate reports.