Fundamentals of Database Management
Systems
[Link] Computer Science Engineering
March 20, 2026
Contents
1 Introduction 3
2 Characteristics of DBMS 4
3 Types of Databases 5
3.1 Relational Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
3.2 NoSQL Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
3.3 Distributed Databases . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
4 Database Models 6
4.1 Hierarchical Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
4.2 Network Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
4.3 Relational Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6
5 Relational Model Concepts 7
5.1 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
5.2 Attributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
5.3 Tuples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7
6 Keys in DBMS 8
6.1 Primary Key . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
6.2 Foreign Key . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
6.3 Candidate Key . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
7 SQL (Structured Query Language) 9
7.1 Types of SQL Commands . . . . . . . . . . . . . . . . . . . . . . . . . . 9
8 Normalization 10
8.1 Normal Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
9 Transactions 11
9.1 ACID Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
10 Concurrency Control 12
11 Database Security 13
11.1 Security Measures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
12 Advantages of DBMS 14
1
13 Disadvantages 15
14 Applications of DBMS 16
15 Conclusion 17
2
Chapter 1
Introduction
A Database Management System (DBMS) is software that allows users to create, manage,
and manipulate databases. It provides a systematic way to store, retrieve, and organize
data efficiently. In the modern world, where data plays a crucial role, DBMS is an
essential component of almost every application.
Databases are used in banking systems, educational institutions, healthcare, e-commerce
platforms, and many other areas. A DBMS ensures that data is stored securely and can
be accessed quickly when required.
3
Chapter 2
Characteristics of DBMS
A DBMS has several important characteristics that make it useful for handling large
amounts of data.
• Data Independence
• Data Integrity
• Data Security
• Data Consistency
• Reduced Data Redundancy
These features help in maintaining accuracy and reliability of data.
4
Chapter 3
Types of Databases
Databases can be classified into different types based on their structure and usage.
3.1 Relational Databases
These databases store data in tables consisting of rows and columns. Examples include
MySQL and Oracle.
3.2 NoSQL Databases
NoSQL databases are used for handling unstructured data. Examples include MongoDB
and Cassandra.
3.3 Distributed Databases
Data is stored across multiple locations but appears as a single database to users.
5
Chapter 4
Database Models
Database models define how data is structured and accessed.
4.1 Hierarchical Model
Data is organized in a tree-like structure.
4.2 Network Model
Allows multiple relationships between data.
4.3 Relational Model
Uses tables to represent data and relationships.
6
Chapter 5
Relational Model Concepts
The relational model is the most widely used database model.
5.1 Tables
Data is stored in tables called relations.
5.2 Attributes
Columns in a table represent attributes.
5.3 Tuples
Rows in a table represent records.
7
Chapter 6
Keys in DBMS
Keys are used to uniquely identify records in a table.
6.1 Primary Key
A unique identifier for each record.
6.2 Foreign Key
Links two tables together.
6.3 Candidate Key
A set of attributes that can uniquely identify a record.
8
Chapter 7
SQL (Structured Query Language)
SQL is used to interact with databases.
7.1 Types of SQL Commands
• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• DCL (Data Control Language)
• TCL (Transaction Control Language)
9
Chapter 8
Normalization
Normalization is the process of organizing data to reduce redundancy.
8.1 Normal Forms
• First Normal Form (1NF)
• Second Normal Form (2NF)
• Third Normal Form (3NF)
Normalization improves database efficiency.
10
Chapter 9
Transactions
A transaction is a sequence of operations performed as a single unit.
9.1 ACID Properties
• Atomicity
• Consistency
• Isolation
• Durability
These properties ensure reliable database operations.
11
Chapter 10
Concurrency Control
Concurrency control ensures that multiple users can access the database without conflicts.
12
Chapter 11
Database Security
Database security protects data from unauthorized access and threats.
11.1 Security Measures
• Authentication
• Authorization
• Encryption
13
Chapter 12
Advantages of DBMS
• Efficient data management
• Improved data sharing
• Better data security
14
Chapter 13
Disadvantages
• High cost
• Complexity
• Performance overhead
15
Chapter 14
Applications of DBMS
• Banking systems
• Airline reservation systems
• Online shopping platforms
16
Chapter 15
Conclusion
Database Management Systems are essential for managing large volumes of data effi-
ciently. Understanding DBMS concepts is crucial for students and professionals in the
field of computer science.
17