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-1 | Course Introduction and Integrity Constraints | Slides | | Lecture-2 | Normalization-I | Slides | | Lecture-3 | Normalization-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-14 | Object Oriented DBMS
| Slides |
Students' seminar presentations
|
|
