Top Posts
Intranet Application Case Studies
Electronic E-commerce and the Trade Cycle
Types of JDBC drivers
C++ Program to implements Constructor Overloading
C++ Program to implements Constructor
C++ Program to calculate the area using classes
C++ Class Program to Store and Display Employee...
Operator Overloading of Decrement — Operator
Postfix Increment ++ Operator Overloading
Top 8 Programming Languages That Will Rule in...
TECHARGE
  • HOME
  • BLOGS
  • TUTORIALS
    • ALL TUTORIALS
    • PROGRAMMING TUTORIALS
      • JAVA TUTORIALS
      • C++ TUTORIAL
      • C PROGRAMMING TUTORIALS
      • PYTHON TUTORIAL
      • KNOWLEDGE MANAGEMENT TUTORIALS
      • DATA STRUCTURE AND ALGORITHM TUTORIALS
      • PROGRAMMING EXAMPLES
        • CPP EXAMPLES
        • JAVA EXAMPLES
        • C++ GRAPHICS PROGRAM
    • PROJECTS
      • PYTHON PROJECTS
      • SWIFT PROJECT
    • PPROGRAMMING QUIZ
    • DBMS TUTORIALS
    • COMPUTER NETWORK TUTORIALS
    • COMPUTER NETWORK SECURITY TUTORIALS
    • E COMMERCE TUTORIALS 
    • AWS TUTORIAL
    • INTERNET OF THINGS
    • CHEATSHEET
  • MORE
    • JOBS AND INTERNSHIPS
    • INTERVIEW PREPARATION
    • TECH BOOK
    • TECH NEWS
    • INSTAGRAM GALLERY
    • UNIVERSITY PAPERS
    • MNC TWEETS
    • THINKECO INITIATIVES
    • WEB STORIES
    • CONTACT US
  • WRITE +
  • ABOUT US
Dbms Tutorials

Introduction to DBMS

by anupmaurya December 8, 2022
written by anupmaurya 0 comment
2.3K

Table of Contents

    • What is Data ?
  • What is Database?
  • Purpose of Database
  • Type of Databases
  • What is DBMS?
  • Components of DBMS
  • Popular DBMS Software
  • Application of DBMS
  • Advantages of DBMS
  • Disadvantage of DBMS

In this article, you’ll learn about what is data, database, database management system (DBMS) and its application, as well as advantages and disadvantages.

What is Data ?

Data is a raw fact and figures such as the name of a person, age, the location where is based, or any collection of a distinct small unit of information. It can be used in a variety of forms like text, numbers, media, bytes, etc.

What is Database?

A database is a collection of interrelated data and a database system is basically computer-based record keeping.

Purpose of Database

  • Database reduce the data redundancy (Duplication of data) to a large extent.
  • Database can control data inconsistency to a large extent.
  • Databases facilitate sharing of data.
  • Database enforce standards.
  • Databases can ensure data security (protection of data against accidental or intentional disclosure to unauthorized persons, or unauthorized modification or destruction).
  • Integrity can be maintained.

Type of Databases

A DBMS can support many different types of databases. Databases can be classified according to the number of users, the database location, and the expected type and extent of use.

  • Number of users: Single-User Database or Multiple User Database( Work-group or Enterprise).
  • Data Location: Centralized or Distributed Database.
  • Data Usage: Operational or Data Warehouse Database.

What is DBMS?

A database is an organized, persistent collection of data of an organization. The Database Management System is a collection of interrelated data (usually called a database) and a set of programs to access, update and manage those data (which form part of the management system).

Or DBMS is a software package to facilitate the creation and maintenance of computerized databases. Its general purpose is to:

  • Defining: Specifying data types and structure, and constraints for data to be stored.
  • Construction: Storing data in a storage medium.
  • Manipulating: Involve querying, updating, and generating results.
  • Sharing: Allowing multiple users and programs to access data simultaneously.

Components of DBMS

  1. Data
  2. Hardware
  3. Software
  4. Users

Popular DBMS Software

Popular-DBMS-Software
Popular-DBMS-Software

Here, is the list of some popular DBMS systems:

  • MySQL
  • Microsoft Access
  • Oracle
  • PostgreSQL
  • dBASE
  • FoxPro
  • SQLite
  • IBM DB2
  • LibreOffice Base
  • MariaDB
  • Microsoft SQL Server etc.

Application of DBMS

SectorUse of DBMS
BankingFor customer information, account activities, payments, deposits, loans, etc.
AirlinesFor reservations and schedule information.
UniversitiesFor student information, course registrations, colleges, and grades.
TelecommunicationIt helps to keep call records, monthly bills, maintaining balances, etc.
FinanceFor storing information about stock, sales, and purchases of financial instruments like stocks and bonds.
SalesUse for storing customer, product & sales information.
ManufacturingIt is used for the management of the supply chain and for tracking the production of items. Inventories status in warehouses.
HR ManagementFor information about employees, salaries, payroll, deduction, generation of paychecks, etc.
Application of DBMS

Advantages of DBMS

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

Disadvantage of DBMS

DBMS may offer plenty of advantages but, it has certain flaws-

  • Cost of Hardware and Software of a DBMS is quite high which increases the budget of your organization.
  • Most database management systems are often complex systems, so training for users to use the DBMS is required.
  • In some organizations, all data is integrated into a single database which can be damaged because of electric failure or database is corrupted on the storage media
  • Use of the same program at a time by many users sometimes lead to the loss of some data.
DatabaseDBMSmySqlRDBMSSchema
Share 12 FacebookTwitterLinkedinRedditWhatsappTelegramEmail
anupmaurya

Hey there, My name is Anup Maurya. I was born with love with programming and worked with TCS. One of best global (IT) services and consulting company as System Administrator . I also love graphics designing. It's my pleasure to have you here.

previous post
Extending Interface
next post
DBMS Architecture and Data Abstraction

You may also like

Functional Dependency

Normalization in DBMS

Boyce Codd normal form (BCNF)

Third Normal form (3NF)

Second Normal Form (2NF)

SQL Tutorial

Entity Relationship Diagram – ER Diagram in DBMS

Relational DBMS

Difference between DBMS and File System

Database Models in DBMS

DBMS TUTORIAL

  • DBMS Introduction
  • Relational DBMS
  • DBMS Architecture and Data Abstraction
  • Data Abstraction
  • Different types of Database Users
  • Characteristics of DBMS
  • Types of database utilities and its functions
  • DBMS Functions
  • Relational Model Concepts
  • Difference between DBMS and File System
  • Entity Relationship Diagram – ER Diagram in DBMS
  • Functional Dependency
  • Normalization in DBMS
  • Closure in DBMS | How to Find Closure
  • Second Normal Form (2NF)
  • Third Normal form (3NF)
  • Boyce Codd normal form (BCNF)
  • Transaction in DBMS
  • Transaction property
  • States of Transactions
  • Indexing in DBMS
  • Hashing in DBMS
  • Schedule in DBMS
  • Concurrency Control in DBMS
  • Lock Based Protocols in DBMS
  • Serializability in DBMS
  • Indexed sequential access method (ISAM)
  • DBMS Interview Questions

Words from Readers

Its a very pleasant environment to be on a very interactive learning platform which helps me to enhance my skill set to move forward in an IT marathon.

–Akash Raj

SQL Tutorial

  • SQL Introduction
  • SQL Datatypes
  • SQL Commands

Recent Posts

  • Intranet Application Case Studies

    March 21, 2023
  • Electronic E-commerce and the Trade Cycle

    March 21, 2023
  • Types of JDBC drivers

    December 28, 2022

EDUCATIONAL

  • Top 8 Programming Languages That Will Rule in 2023

  • Difference between Google Cloud Platform, AWS and Azure

  • Google Apps You Should Be Using in 2022

  • Top Sites From Where You Can Learn

  • PyScript: Python in the Browser

  • Best Fake Email Generators (Free Temporary Email Address)

  • How to Find Out Who Owns a Domain Name

  • Mobile phone brands by country of origin

  • How to start a new YouTube Channel in 2022

  • Best way to use google search you won’t believe exist

CHEATSHEET

  • Git and Github 2022 Cheat Sheet

  • ReactJs Cheatsheet

  • Linux Commands Cheat Sheet

  • C Programming language Cheatsheet

  • Scala Cheatsheet

  • MySQL Cheatsheet

  • Javascript Cheatsheet

PROJECTS

  • Print emojis using python without any module

  • Country Date and Time using Python

  • Covid-19 Tracker Application Using Python

  • Python | GUI Calendar using Tkinter

  • Shutdown Computer with Voice Using Python

  • Python GUI Calculator using Tkinter

  • Convert an Image to ASCII art using Python

  • Python YouTube Downloader with Pytube

  • Tic-Tac-Toe using Python

  • Draw Indian Flag using Python

  • Drawing Pikachu with the Python turtle library

  • Word Dictionary using Tkinter

TECH NEWS

  • 5+ Best Humanoid Robots In The World

  • Reliance Jio launches streaming platform JioGamesWatch

  • Microsoft Teams down for thousands of users

  • Carbon: Google programming language as a C++ successor

JOBS AND INTERNSHIPS

  • Accenture Off Campus Hiring Drive | Associate Job | Program Project Management | 2019-2022 Batch| Apply Now

    September 1, 2022

@2019-21 - All Right Reserved. Designed and Developed by Techarge

TECHARGE
  • HOME
  • BLOGS
  • TUTORIALS
    • ALL TUTORIALS
    • PROGRAMMING TUTORIALS
      • JAVA TUTORIALS
      • C++ TUTORIAL
      • C PROGRAMMING TUTORIALS
      • PYTHON TUTORIAL
      • KNOWLEDGE MANAGEMENT TUTORIALS
      • DATA STRUCTURE AND ALGORITHM TUTORIALS
      • PROGRAMMING EXAMPLES
        • CPP EXAMPLES
        • JAVA EXAMPLES
        • C++ GRAPHICS PROGRAM
    • PROJECTS
      • PYTHON PROJECTS
      • SWIFT PROJECT
    • PPROGRAMMING QUIZ
    • DBMS TUTORIALS
    • COMPUTER NETWORK TUTORIALS
    • COMPUTER NETWORK SECURITY TUTORIALS
    • E COMMERCE TUTORIALS 
    • AWS TUTORIAL
    • INTERNET OF THINGS
    • CHEATSHEET
  • MORE
    • JOBS AND INTERNSHIPS
    • INTERVIEW PREPARATION
    • TECH BOOK
    • TECH NEWS
    • INSTAGRAM GALLERY
    • UNIVERSITY PAPERS
    • MNC TWEETS
    • THINKECO INITIATIVES
    • WEB STORIES
    • CONTACT US
  • WRITE +
  • ABOUT US