Database Management

Lecture 01 Recap + Data Independence & ER [ALB]

Introduction to Databases [FEK]

Introduction Overview [NNC]

Introduction to DBMS [Farhan]

Difference Between Data & Information [Farhan]

File System vs DBMS [Farhan]

Components of DBMS [Farhan]

2-Tier Architecture [Farhan]

3-Tier Architecture [Farhan]

OLAP vs OLTP [Farhan]

Data Abstraction [Farhan]

Data Independence [Farhan]

Types of Schema [Farhan]

3-Schema Architecture [Farhan]

Unique Constraint [Farhan]

NOT NULL & DEFAULT Constraints [Farhan]

Check Constraint [Farhan]

Candidate Key, Super Key, Alternative Key [Farhan]

Primary Key [Farhan]

Primary Key — DROP Primary Key [Farhan]

Foreign Key [Farhan]

Foreign Key — DROP Foreign Key [Farhan]

ER Diagram [ALB]

ER Diagram [FEK]

ER Diagram [FEK]

ER Diagram Spring 2025 [RBR]

ER Diagram Summer 2025 [RBR]

ER Diagram Overview [NNC]

ER Diagram Problem Solving [NNC]

ER Diagram [Farhan]

Symbols of ER Diagram [Farhan]

Types of Entity — Strong & Weak [Farhan]

Types of Attributes [Farhan]

Types of Relationship — One to One [Farhan]

Types of Relationship — One to Many [Farhan]

Types of Relationship — Many to Many [Farhan]

Degree of Relationship [Farhan]

Participation Constraints [Farhan]

EER Diagram [FEK]

EER Model Overview [NNC]

Relational Data Model Part 1 [RBR]

Relational Data Model Part 2 [RBR]

Relational Model [Farhan]

Integrity Constraints [Farhan]

Mapping EER to Relations — Intro [RBR]

Mapping EER to Relations — Method 8A & 8B [RBR]

Mapping EER to Relations — Method 8C & 8D [RBR]

ER to Schema Feb 2024 [RBR]

ER to Schema & Update Anomalies [ALB]

ER/EER to Schema [Niloy]

ER to Schema Conversion [MTT]

EER to Schema Conversion [MTT]

Midterm Review [FEK]

Normalization [ALB]

Normalization [FEK]

Normalization [Niloy]

Normalization Intro Part 1 [MTT]

Normalization Intro Part 2 [MTT]

Normalization Problem Solving [MTT]

Normalization, Hashing & SQL Examples [RBR]

Normalization & Indexing Examples — Spring 2026 [RBR]

Normalization [Farhan]

First Normal Form — 1NF [Farhan]

Second Normal Form — 2NF [Farhan]

Third Normal Form — 3NF [Farhan]

Boyce-Codd Normal Form — BCNF [Farhan]

Fourth Normal Form — 4NF [Farhan]

Fifth Normal Form — 5NF [Farhan]

Indexing [Niloy]

B+ Tree [Niloy]

Hashing [Niloy]

B+ Tree Deletion [ALB]

Indexing [FEK]

B+ Tree [FEK]

B+ Tree Introduction — Spring 2024 [RBR]

B+ Tree Insertion & Hashing — Spring 2024 [RBR]

B+ Tree Insertion & Hashing — Fall 2025 [RBR]

Indexing, Hashing, Transaction & SQL [RBR]

Indexing Introduction [MTT]

Database Hashing [MTT]

Indexing + Hashing [MTT]

B+ Tree [MTT]

Introduction to File Organization [Farhan]

Sequential File Organization [Farhan]

Heap File Organization [Farhan]

Hash File Organization [Farhan]

ISAM — Indexed Sequential Access Method [Farhan]

B+ Tree File Organization [Farhan]

Cluster File Organization [Farhan]

MV2PL — Multiversion Two-Phase Locking [ALB]

MVCC and Timestamp Ordering [ALB]

Multiversion Timestamp Ordering Example [ALB]

Transaction Log Based Recovery [ALB]

Transaction, Concurrency Control & Recovery [ALB]

Transaction and SQL Review [FEK]

Transaction Management — Spring 2024 [RBR]

Transaction & Concurrency Control — Spring 2026 [RBR]

Transaction [MTT]

Transaction in DBMS [Farhan]

COMMIT & ROLLBACK [Farhan]

ACID Properties [Farhan]

Serial vs Parallel Schedules [Farhan]

Lost Update Problem [Farhan]

Non-Repeatable Read Problem [Farhan]

Dirty Read Problem [Farhan]

Recoverable vs Irrecoverable Schedule [Farhan]

Cascading Rollback [Farhan]

Cascadeless Schedule [Farhan]

Strict Schedule [Farhan]

Serializability [Farhan]

Conflict Serializability [Farhan]

View Serializability [Farhan]

Relational Algebra Examples [ALB]

Relational Algebra Spring 2026 [RBR]

Relational Algebra Types [Farhan]

Selection Operator [Farhan]

Projection Operator [Farhan]

Rename Operator [Farhan]

Union Operator [Farhan]

Set Intersection Operation [Farhan]

Set Difference Operation [Farhan]

Cartesian Product [Farhan]

Division Operator [Farhan]

Introduction to Joins [Farhan]

Theta Join [Farhan]

Equi Join [Farhan]

Natural Join [Farhan]

Left Outer Join [Farhan]

Right Outer Join [Farhan]

Full Outer Join [Farhan]

Deletion Operator [Farhan]

Insertion Operator [Farhan]

Update Operation [Farhan]

Final Quiz Solving, Final Review[FEK]

SQL [MTT]

SQL Lab 2 — Spring 2025 [RBR]

SQL Lab 2 — Summer 2025 [RBR]

Introduction to SQL [Farhan]

Types of SQL Commands [Farhan]

CREATE Command — DDL [Farhan]

Index — CREATE Command [Farhan]

ALTER, DROP, RENAME, TRUNCATE [Farhan]

INSERT Command — DML [Farhan]

UPDATE Command — DML [Farhan]

DELETE Command — DML [Farhan]

SELECT Command [Farhan]

SQL Operators [Farhan]

WHERE Clause [Farhan]

AND, OR, NOT Operators [Farhan]

LIKE & NOT LIKE Operators [Farhan]

Aggregate Functions [Farhan]

Subquery [Farhan]

IN & NOT IN Operators [Farhan]

EXISTS & NOT EXISTS Operators [Farhan]

BETWEEN & NOT BETWEEN Operators [Farhan]

GROUP BY Statement [Farhan]

INNER JOIN [Farhan]

LEFT JOIN [Farhan]

RIGHT JOIN [Farhan]

CROSS JOIN [Farhan]

ORDER BY Keyword [Farhan]

LIMIT Clause [Farhan]

HAVING Clause [Farhan]

SQL Problem Solving 1 — Second Highest Salary [Farhan]

SQL Problem Solving 2 — Dept Wise Salary [Farhan]

SQL Problem Solving 3 — Students CGPA [Farhan]

SQL Problem Solving 4 — Students Admitted 2022 [Farhan]

Demo Project Part 1 [RBR]

Demo Project Part 2 [RBR]