This is the second course on Database Management Systems (DBMS).
Database System Concepts, by: Abraham Silberchatz, Henry F. Korth, S. Sudarshan, McGraw Hill, Fourth Edition, 2002
|Storage and File Structure - slides , new slides|
|Indexing and Hashing - new slides|
|Query Processing and Optimization - slides1 , new slides1, slides2|
|Relational Database Design - slides|
|Database System Architectures - slides|
|Object-Oriented Databases - slides|
|Object-Relational Databases - slides|
|Transactions - slides Solutions for Chapter 15 - Transactions Exercises|
|Concurrency Control - slides|
|Distributed Databases - slides|
|30% Midterm exam|
|35% Final exam|
|5% One or more quizzes|
|20% Term Project|
Policy on Attendance:
You need to attend at least 80% of all lectures. If you fail to do so, you will get a zero mark for all the quizzes. Students actively working during lectures (more than 80% of attendance) at the end of Summer school may pretend on upgrading up to 3 points (respective to activity).
Policy on Accounting Previous Results:
For students repeatedly taking DBMS course previously (Spring 2002) earned grades on labs and/or assignment may be accepted strictly in the case of maximum grades values.
Projects and Labs:
You will implement in 'C' a simple database management system. Your labs will be designed to equip you with the skills necessary for the project. Here is Assignment Task
Course corresponds to the DBMS course given by Assoc. Prof. Dr. Z. Bayram and Dr. A.Chefranov in Spring 2002 (for details look at Dr. Z. Bayram home page ).