Course Description:

This is the second course on Database Management Systems (DBMS). 

Textbook:

Database System Concepts, by: Abraham Silberchatz, Henry F. Korth, S. Sudarshan, McGraw Hill, Fourth Edition, 2002

Topics:

Storage and File Structure - slides , new slides
Indexing and Hashing - new slides
Query Processing and Optimization - slides1new slides1, slides2
Midterm
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

Grading:

30% Midterm exam
35% Final exam
5% One or more quizzes
10% Labs
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.

Tools:

MySQL: mysql-3.23.49-win.zip

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 Correspondence:

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 ).