Learn DBMS - from basic

 Topics to be covered

• Introduction of DBMS
• Applications of DBMS
• Advantages of DBMS 

What is Database Management System (DBMS)?

▪ Data - Fact that can be recorded or stored

 • e.g. Person Name, Age, Gender and Weight etc. 

▪ Database - Collection of logically related data 

 • e.g. Books Database in Library, Student Database in University etc. 

▪ Management - Manipulation, Searching and Security of data 

• e.g. Viewing result in GTU website, Searching exam papers in GTU website 

▪ System - Programs or tools used to manage database 

• e.g. SQL Server Studio Express, Oracle 

▪ DBMS - A Database Management System is a software for creating and managing databases. 

▪ Database Management System (DBMS) is a software designed to define, manipulate, retrieve and manage data in a database. 

• e.g. MS SQL Server, Oracle, My SQL, SQLite, MongoDB etc.

 SQL Server, Oracle, My SQL Server

• Applications of DBMS 

▪ DBMS is a computerized record-keeping system. 

▪ DBMS is required where ever data need to be stored. 

    1. E-Commerce (Flipkart, Amazon etc.) 

    2. Online Television Streaming (Hotstar, Amazon Prime etc.) 

    3. Social Media (WhatsApp, Facebook etc.)

    4. Banking & Insurance 

    5. Airline & Railway 

    6. Universities and Colleges/Schools 

    7. Human Resource Department 

    8. Hospitals and Medical Stores 

    9. Government Organizations

• Advantages of DBMS 

1. Reduce data redundancy (duplication) 

    • Avoids unnecessary duplication of data by storing data centrally. 

e.g. 

2. Remove data inconsistency 

    • By eliminating redundancy, data inconsistency can be removed. 

e.g. 

3. Data isolation 

    • A user can easily retrieve proper data as per his/her requirement. 

e.g. 

4. Guaranteed atomicity 

    • Either transaction executes 0% or 100%.

e.g.