Scribd
Upload
16 views3 pages

Database Management System (DBMS) Notes

A Database Management System (DBMS) is software that facilitates the creation, management, and manipulation of databases, with examples including MySQL and Oracle. DBMS eliminates data redundancy, enhances security, and ensures data integrity while supporting concurrent access. It encompasses various types such as hierarchical, network, relational, and object-oriented DBMS, and is essential for modern applications across industries.

Uploaded by

aashnaspeaks
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
16 views3 pages

Database Management System (DBMS) Notes

A Database Management System (DBMS) is software that facilitates the creation, management, and manipulation of databases, with examples including MySQL and Oracle. DBMS eliminates data redundancy, enhances security, and ensures data integrity while supporting concurrent access. It encompasses various types such as hierarchical, network, relational, and object-oriented DBMS, and is essential for modern applications across industries.

Uploaded by

aashnaspeaks
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Database Management System (DBMS)

Notes
B.Tech CSE – Semester IV​
Unit 1: Introduction to DBMS

1. Introduction to DBMS
●​ Definition: A Database Management System (DBMS) is software used to create,
manage, and manipulate databases.​

●​ Examples: MySQL, Oracle, PostgreSQL, SQL Server.​

●​ Need for DBMS:​

○​ Eliminates data redundancy​

○​ Provides data security​

○​ Ensures data integrity​

○​ Supports concurrent access​

2. Characteristics of DBMS
●​ Data abstraction​

●​ Data independence​

●​ Multi-user environment​

●​ Support for transactions​

●​ Backup and recovery​


3. Types of DBMS
1.​ Hierarchical DBMS​

○​ Data organized in a tree-like structure.​

○​ Example: IBM IMS.​

2.​ Network DBMS​

○​ Data represented using nodes and relationships.​

○​ Example: IDMS.​

3.​ Relational DBMS (RDBMS)​

○​ Data stored in tables (rows & columns).​

○​ Example: MySQL, Oracle.​

4.​ Object-Oriented DBMS​

○​ Combines database capabilities with object-oriented programming.​

4. DBMS vs File System

Feature File System DBMS

Data High Low


Redundancy

Security Limited Strong

Querying Manual SQL


(complex) (simpl
e)
Backup & Manual Automati
Recovery c

5. Advantages of DBMS
●​ Efficient data access​

●​ Better data security​

●​ Reduced redundancy​

●​ Improved data sharing​

●​ Enforces integrity constraints​

6. SQL (Structured Query Language) Basics


●​ DDL (Data Definition Language): CREATE, ALTER, DROP​

●​ DML (Data Manipulation Language): INSERT, UPDATE, DELETE​

●​ DCL (Data Control Language): GRANT, REVOKE​

●​ TCL (Transaction Control Language): COMMIT, ROLLBACK​

7. Conclusion
DBMS is the backbone of modern applications. From banking to e-commerce, every industry
relies on efficient database systems for managing and processing information.

You might also like