Advanced DBMS (CSE-203)

Welcome to the homepage of the course Advanced Database Management Systems (CSE-203) for M.Tech. Part-I 2nd Semester, 2011. You will get all the information about the course here.

Class hours
  • Wednesday: 10-15 a.m. to 12:00 noon.
  • Thursday: 1:30 p.m. to 3:20 p.m.
Marks distribution

Total marks - 100 (Written exam - 60, Assignments/Lab/Seminars - 20, Class test - 20)

Course homepage

https://sites.google.com/site/dranirbanmukhopadhyay/cse203

Syllabus outline
  • Database normalization
  • Object oriented database
  • Query processing and optimization
  • Transactions and concurrency control
  • Parallel and distributed DBMS
  • Data warehousing and Data mining
Books
  • Avi Silberschatz, Henry F. Korth, S. Sudarshan, Database System Concepts, McGraw-Hill, USA.
  • C. J. Date, An Introduction to Database Systems, Addison-Wesley Longman Publishing Co., USA.
Course lectures
 
Lecture-1Course Introduction and Integrity Constraints Slides 
Lecture-2   Normalization-I     Slides
Lecture-3Normalization-II Slides
Lecture-4          
Normalization-III
 Slides
Lecture-5          
Transaction Management
 Slides
Lecture-6
Concurrency Control-I
 Slides
Lecture-7-8
Concurrency Control-II
 Slides
Lecture-9
Database Recovery
 Slides
Lecture-10
Distributed DBMS-I
 Slides
Lecture-11-12
Distributed DBMS-II
 Slides
Lecture-13        Distributed Deadlock Detection    
 Slides
Lecture-14Object Oriented DBMS
 Slides

Students' seminar presentations

Comments