Home » Online Computer Education » Learn online DBMS “What is Database Management System (DBMS)” Lesson 3

Learn online DBMS “What is Database Management System (DBMS)” Lesson 3

 

Database Management System (DBMS)
A database management system is a collection of programs that enables users to create, maintain and use a database.It can be viewed as a repository of data that is defined once and then accessed by different users as per their requirements. In the Database approach,there is a single repository of data which is accessed by all the application programs as shown in the example below:

Database Management System (DBMS)

The various operations that need to be performed on a database are as follows:
1. Defining the database – It involves specifying the data type of data that will be stored in the database and also any constraints on that data.
2. Populating the database – It involves storing the data on some storage medium that is controlled by DBMS.
3. Manipulating the database – It involves modifying the database, retrieving data or querying the database, generating reports from the database etc.
4. Sharing the database – Allow multiple users to access the database at the same time.
5. Protecting the database – To protect the database from software and hardware failures and also protecting it from unauthorized access.
6. Maintain the database – Adapt to the changing requirements.

Some examples of DBMS are – MySQL, Oracle, DB2, IMS, IDS etc.

About

The main objective of this website is to provide quality study material to all students (from 1st to 12th class of any board) irrespective of their background as our motto is “Education for Everyone”. It is also a very good platform for teachers who want to share their valuable knowledge.

Leave a Reply

Your email address will not be published.