DBMS Tutorial

This tutorial will help you learn every thing about DataBase Management System (DBMS) even if you are a beginner.

Before learning about the DBMS in this tutorial let’s first understand the topics Data and Database for better idea over Database Management System(DBMS).

Data

Data is information processed or stored in a computer. This data can be in the form of text documents, images, audio clips, software programs, or any other types of data. Computer data is be processed by the computer’s CPU and is stored in files and folders on the secondary storage devices of a computer. Data is a collection of ones and zeros, known as binary code. As all computer data is in binary format, it can be easily created, processed, saved, and stored digitally. This allows data to be transferred from one computer to another.

Database

A database is an organized collection of inter-related data which is stored and accessed electronically from a computer system. When databases are more complex they are developed using formal design and modeling techniques. In a database the data is organized in the form of tables, views, schemas, reports etc. The databases make the data management easy. A database supports storage and  manipulation of data.

For example let’s consider facebook. It will store, manipulate and present data related to members, their friends, member activities, messages, advertisements and lot more on their database.

database management system

Database Management System

A database management system is a software that is used to manage or manipulate a database. The full form of DBMS is DataBase Management System

DBMS allows users to perform the following tasks:

Data Definition: It is useful in creation, modification and removal of definitions that define the organization of data in database.

Data Updation: It used for insertion, deletion and modification of the actual data in the database.

Data Retrieval: It useful in retrieval of data from database which can be used by applications for various purposes.

User Administration: It is used for registering and monitoring users, enforcing data security, monitoring the performance, maintaining the data integrity, dealing with concurrency control and for recovering the information corrupted by unexpected failure.

Types of DBMS

There are four types of database management systems, they are given below.

Hierarchical DBMS, Network model, Relational model & Object-Oriented DBMS

types of DBMS

Hierarchical DBMS

In this type the data is organized in a tree-like structure. The data is stored Hierarchically (top down or bottom up) format. Data is represented using  parent-child relationship. In Hierarchical database management system parent can have many children, but a child has only one parent.

Network Model

This model allows each child to have multiple parents. Network model helps you to address the need to model more complex relationships like as the orders/parts many-to-many relationships. This model, entities are organized in graph format which can be accessed through several paths.

Relational model

Relational DBMS is the most widely used DBMS model. As it is one of the easiest. This model is based on organizing the data in rows and columns of the table. Relational model is stored in fixed structures and manipulated using SQL(Structured Query Language).

Object-Oriented Model

In this model the data is stored in the form of objects. The structure called classes will display data within it. It defines a database as a collection of objects which stores both values of data members and operations.

Advantages of DBMS

  • DBMS serves as an efficient handler to balance the needs of many applications using the same data.
  • Uniform administration procedures for data manipulation.
  • Application programmers are never exposed to details of data representation and storage.
  • It uses various powerful functions to store and retrieve data efficiently.
  • It offers Data Integrity and Security.
  • Reduces Application Development Time.
  • It implies integrity constraints to get a high level protection against the prohibited access to data.
  • It schedules concurrent access to data in such a way that only one user can access the same data at a time.
  • It offers a wide variety of techniques to store & retrieve data.

Disadvantage of DBMS

Database Management System has many advantages but, it also has some disadvantages.

  • Cost of Software Hardware of a DBMS is high which increases the budget of organization.
  • Most of the database management systems are complex, so it requires the training for users.
  • In some organizations, all the data is stored in a single database which can be damaged because of electric failure or database is corrupted on the storage media.
  • Use of the same program by many users at same time may lead to the loss of some data.
  • It can’t perform highly complex calculations.

Reference: Database Management Systems

Hope this tutorial on DBMS helped you in getting an idea over it.

Also read File system vs DBMS

FAQ?

What is a DBMS?

A database management system is a software that is used to manage or manipulate a database.

What are the types of DBMS?


There are four types of database management systems, they are given below.
Hierarchical DBMS, Network model, Relational model & Object-Oriented DBMS

What are the examples of DBMS?

Some of the DBMS examples include MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, and FoxPro.

For more topics related to computer science stay connected to Notes For Geeks

4 thoughts on “DBMS Tutorial”

  1. I am really impressed with your writing skills as well as with the layout on your blog. Is this a paid theme or did you customize it yourself? Either way keep up the excellent quality writing, it is rare to see a great blog like this one nowadays..

    Reply

Leave a comment