Skip to main content

Database Systems, Spring 2010 (March-May)

Teaching: Mondays and Thirsdays (9:00-12.00 & 12.45-15.00). Split between lectures, practical, programming, and problem solving sessions.

Professor: Sergei Vorobyov, Ovastova, sergei AT setur DOT fo

Course Description and Scope

The course provides theoretical backgrounds and practical knowledge about contemporary data bases, including entity-relationship model, relational database model, standard query language (SQL), integrity constraints,  relational database design, object-oriented databases, storage and file structure, indexing, hashing, query processing, transactions, concurrency control, failure and recovery, database systems architecture, parallel,  distributed databases. During the course the student will conduct practical project work on data base management and development, using MySQL.

Textbook

Database Systems Concepts,
by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan
6th edition, McGraw Hills Co., 2010

Success Evaluation Criteria

Welcome to the course!

The whole course values 7.5 ETCS points.
There will be 3 compulsory homework assignments and the final exam counting in proportions 1:1:1:2, respectively, or 20%:20%:20%:%40 toward your final success score.
If you succeed A percent at assignment 1, B% at 2, C% at 3, and D% at the final exam, then your final score will be counted as [1.5*(A+B+C)+3*D] / 7.5=[A+B+C+2D]/5, transferred to the old or new marking scale.
The question of the external referee is currently open (especially because of the interview part of the exam).

Course Schedule and Topics to be Covered

(The schedule is preliminary and will be dynamically adjusted as we go.)

1. Thursday, 11 March

  1. Introduction (Ch 1)
  2. Entity-relationship model (Ch 2)
  3. Installing and initial administration of MySQL

2. Monday, 15 March

  1. Relational Model (Ch 3)
  2. Standard Query Language, SQL (Ch 4)
  3. Creating databases and writing queries in MySQL 

3. Thursday, 18 March

  1. ...
  2. ...

4. Monday, 22 March

  1. ...
  2. ...

5. Thursday, 25 March

  1. ...
  2. ...
  3. First assignment due

(27 Mar - 5 Apr, Easter Vacations)

6. Thursday, 8 April

  1. ...
  2. ...

7. Monday, 12 April

  1. ...
  2. ...

8. Thursday, 15 April

  1. ...
  2. ...

9. Monday, 19 April

  1. ...
  2. ...

10. Thursday, 22 April

  1. ...
  2. ...
  3. Second assignment due

11. Monday, 26 April

  1. ...
  2. ...

12. Thursday, 29 April

  1. ...
  2. ...

13. Monday, 3 May

  1. ...
  2. ...

14. Wednesday, 5 May (???)

  1. ...
  2. ...
  3. Third assignment due

Monday, 10 May - Final Exam

  1. 4 hours written exam
  2. Consists of a series of problems/projects
  3. Books and computers are allowed
  4. Interaction is not allowed
  5. Concluded with the interview/questioning