Lecture 6: Database Management Systems (DBMS)
A Database Management System (DBMS) is essential in modern computing, as it provides an organized and efficient way to store, manage, and retrieve data. In this lecture, we will explore the foundations of DBMS, its components, architecture, and importance in Computer Science Engineering.
1. What is a Database?
A Database is a structured collection of related data that can be accessed, managed, and updated easily. Unlike files, databases store data in a systematic way to reduce redundancy and improve efficiency.
Example: A university database may store information about students, courses, faculty, and grades.
2. What is DBMS?
A Database Management System (DBMS) is software that allows users and applications to create, manage, and manipulate databases.
- Provides data security and integrity.
- Enables concurrent access by multiple users.
- Supports data recovery in case of system failures.
3. Functions of DBMS
- Data Storage Management – Efficiently stores large volumes of data.
- Data Retrieval – Allows querying of data using SQL.
- Data Manipulation – Enables insert, update, and delete operations.
- Transaction Management – Ensures ACID properties (Atomicity, Consistency, Isolation, Durability).
- Concurrency Control – Manages simultaneous access by multiple users.
- Data Security – Restricts unauthorized access to sensitive data.
4. Types of Databases
- Hierarchical Database – Data organized in a tree structure.
- Network Database – Uses graphs with complex relationships.
- Relational Database – Stores data in tables (rows & columns).
- NoSQL Database – Stores unstructured or semi-structured data (JSON, key-value, documents).
- Object-Oriented Database – Integrates object-oriented programming with databases.
5. Database Models
The most widely used database model is the Relational Model, where data is stored in tables. Each table has rows (records) and columns (attributes).
Example: Student Table ------------------------------- ID | Name | Course | Grade ------------------------------- 1 | Alice | CS101 | A 2 | John | CS102 | B 3 | Maria | CS101 | A+
6. Database Architecture
DBMS follows a three-level architecture (ANSI/SPARC Model):
- External Level – User’s view of data.
- Conceptual Level – Logical structure of the entire database.
- Internal Level – Physical storage details.
7. SQL – Structured Query Language
SQL is the standard language for interacting with relational databases.
-- Create a table
CREATE TABLE Students (
ID INT PRIMARY KEY,
Name VARCHAR(50),
Course VARCHAR(50),
Grade CHAR(2)
);
-- Insert data
INSERT INTO Students VALUES (1, 'Alice', 'CS101', 'A');
-- Retrieve data
SELECT * FROM Students WHERE Course = 'CS101';
8. Advantages of DBMS
- Reduces data redundancy.
- Ensures data consistency.
- Supports data sharing among users.
- Provides backup and recovery.
- Improves data security.
9. Applications of DBMS
- Banking Systems – Transactions, customer accounts.
- Airline Reservations – Scheduling and booking flights.
- E-commerce – Product catalogs, customer orders.
- Education – Student records, grading systems.
- Healthcare – Patient information and medical history.
“Databases are the backbone of information systems. Without them, modern applications would struggle to manage and process massive amounts of data.”
10. Summary of Key Points
- A database is an organized collection of related data.
- DBMS manages data storage, retrieval, and security.
- Relational databases are the most common, using tables and SQL.
- DBMS ensures ACID properties for reliable transactions.
- Applications range from banking to healthcare and education.
✦ Lecture 6 prepared under the authority of English Master Institute (EMI) Worldwide ✦
English Master Institute (EMI) Worldwide 