DBMS Notes
CSE DBMS Course

Learn Database Management Systems

Everything you need to understand databases—from basic concepts to advanced topics. Built to help you actually learn, not just memorize.

Jump into Unit 1View Full Syllabus

What you'll learn

The course covers everything from data modeling to transaction management.

Learning Goals

  • CLO01Have a broad understanding of database concepts and database management system software
  • CLO02Have a high-level understanding of major DBMS components and their function
  • CLO03Be able to model an application's data requirements using conceptual modelling tools like ER diagrams and design database schemas based on the conceptual model.
  • CLO04Be able to write SQL commands to create tables and indexes, insert/update/delete data, and query data in a relational DBMS.
  • CLO05Be able to program a data-intensive application using DBMS APIs.

Skills You'll Build

  • CO01Define core database concepts including data, information, database management systems, and transaction management systems.
  • CO02Explain fundamental database system principles, including distinctions among data, information, databases, and DBMS; DBMS architecture and components; data independence; database design constraints; normalization foundations; and query processing concepts.
  • CO03Apply database modeling and implementation techniques by designing conceptual and logical data models (ER diagrams and relational schemas), utilizing appropriate database models, and implementing database solutions using SQL and advanced PL/SQL constructs.
  • CO04Analyze database design quality and integrity by identifying dependencies, applying normalization strategies, and validating schemas using standard normal forms and design principles.
  • CO05Analyze database performance and reliability mechanisms, including transaction management, concurrency control, recovery, serializability, query processing strategies, indexing techniques, and advanced database.

Course content

Five units covering the complete DBMS curriculum

1

UNIT I: Basic Concepts

4 topics

Data Vs Information and Database FundamentalsComponents of DBMS and ArchitectureData Modelling and Entity Relationship ModelDatabase Models: Relational, Network, Hierarchical, Object-Oriented
2

UNIT II: Relational Database and SQL

3 topics

Relational Algebra and OperationsTuple and Domain Relational CalculusSQL DDL, DML, and PL/SQL
3

UNIT III: Database Design and Normalization

1 topics

Keys, Constraints, Functional Dependencies, and Normalization
4

UNIT IV: Transaction Processing and Concurrency Control

1 topics

Transactions, ACID Properties, Concurrency Control, and Recovery
5

UNIT V: Query Processing and Advanced Databases

1 topics

Query Processing, Indexing (B-tree, Hashing), and Advanced Database Systems