Database Management System Theory & Lab

Course Overview

This course provides a comprehensive introduction to understanding the principles, techniques and approaches that constitute the structure of database management system. To understand basic database concepts, applications, data models, schemas and instances, to familiarize Entity Relationship model for a database, to demonstrate the use of constraints and relational algebra operations, to describe the basics of SQL and construct queries using SQL, to emphasize the importance of normalization in databases and to demonstrate the basic concepts of transaction processing and concurrency control.

Course Details

• Instructor: Utkalika Satapathy
• Duration: 40 Hours
• Credits: 4
• Prerequisites: Basic understanding of programming concepts and maths (Relation, Function, Set, Logic)

Course Materials

Lecture Slides

• Slides

Course Syllabus

• Course Syllabus

Textbooks

• Elmasri Navate, Fundamentals of Database Systems, Pearson Education, India.
• Abraham Silberschatz, Henry F. Korth, S. Sudarshan (2005), Database System Concepts, 5th edition, McGraw-Hill, New Delhi, India.
• Raghurama Krishnan, Johannes Gehrke, Database Management Systems, 3rd edition, Tata McGraw Hill, New Delhi, India.
• Peter Rob, Carlos Coronel (2009), Database Systems Design, Implementation and Management, 7th edition.
• Alex Petrov , Database Internals: A Deep Dive into How Distributed Data Systems Work, 2019

Theory Grading Policy

• Quizess: 15%
• Midterm Exam: 30%
• Final Exam: 50%
• Teacher’s Assesment: 5%

DBMS Lab

Lab Materials

• Lab Manual
• Introduction to SQL

Reference Books

1. SQL Cookbook by Anthony Molinaro
2. Learning SQL By Alan Beaulieu
3. SQL The Ultimate Beginner’s Guide To Learn SQL Programming Step By Step By Mark Reed
4. SQL in 10 minutes, Sam’s Teach Yourself by Ben Forta
5. Head First SQL by Lynn Beighley

Lab Grading Policy

• Lab Assessment: 50%
• Viva: 20%
• Lab Sessions: 20%
• Attendance: 5%
• Lab Record: 5%