Spring 2026 · Undergraduate
Database Management System
4 Credits 40 Hours Undergraduate Course
Department of Computer Science, IIIT Bhubaneswar
A comprehensive introduction to the principles and structure of database management systems — covering data models, ER modelling, the relational model, relational algebra, SQL, normalization, and transaction processing & concurrency control.
Instructor
Utkalika Satapathy
Duration
40 Hours
Credits
4
Prerequisite
Programming & discrete maths
Class Schedule
8 sessionsWk 1Introduction, Data Models, Schemas & Instances
Wk 2Entity–Relationship (ER) Model
Wk 3Relational Model & Constraints
Wk 4Relational Algebra
Wk 5SQL: Basics & Query Construction
Wk 6Advanced SQL
Wk 7Normalization
Wk 8Transaction Processing & Concurrency Control
Materials
Lecture Slides & Syllabus
Textbooks
5 references Elmasri & Navathe — Fundamentals of Database Systems Silberschatz, Korth, Sudarshan — Database System Concepts, 5th Ed. Ramakrishnan & Gehrke — Database Management Systems, 3rd Ed. Rob & Coronel — Database Systems, 7th Ed. Alex Petrov — Database Internals
Grading
- Quizzes15%
- Midterm Exam30%
- Final Exam50%
- Teacher's Assessment5%
Hands-on SQL lab accompanying the DBMS theory — from SQL basics through query construction and database design.
Lab Materials
Lab Materials
Reference Books
5 books SQL Cookbook — Anthony Molinaro Learning SQL — Alan Beaulieu SQL: The Ultimate Beginner's Guide — Mark Reed SQL in 10 Minutes — Ben Forta Head First SQL — Lynn Beighley
Lab Grading
- Lab Assessment50%
- Viva20%
- Lab Sessions20%
- Attendance5%
- Lab Record5%