No polls currently selected on this page!


Repository is empty

Database systems

Code: 45693
ECTS: 5.0
Lecturers in charge: prof. dr. sc. Robert Manger - Lectures
Lecturers: doc. dr. sc. Marko Horvat - Exercises
Luka Mikec, mag. math. - Exercises
English level:


All teaching activities will be held in Croatian. However, foreign students in mixed groups will have the opportunity to attend additional office hours with the lecturer and teaching assistants in English to help master the course materials. Additionally, the lecturer will refer foreign students to the corresponding literature in English, as well as give them the possibility of taking the associated exams in English.

1. komponenta

Lecture typeTotal
Lectures 30
Exercises 15
* Load is given in academic hour (1 academic hour = 45 minutes)
COURSE AIMS AND OBJECTIVES: Acquiring basic knowledge on relational database systems, and on conceptual, logical and physical data modeling. Mastering the SQL language for working with relational databases.

1. Introduction to database systems. Basic concepts and definitions. Database architecture. Database lifecycle.
2. Relational data modeling. Entity-relationship modeling. Relational modeling. Functional and multi-valued dependencies. Normalization.
3. Relational database languages. Relational algebra. Relational calculus. Structured query language - SQL. Query optimization.
4. Physical structure of a database. Blocks, records, files, pointers. Access based on the primary key. Access based on other data. Hash tables, indices, B-trees.
5. Implementation of relational operations. Implementing the natural join. Implementing other operations. Optimal evaluation of algebraic expressions.
6. Integrity and security issues. Maintaining integrity. Concurrent access. Recovery from failure. Protection from unauthorized access.
  1. C. J. Date: An Introduction to Database Systems, 7th edition
  2. M. Widenius, D. Axmark: MySQL Reference Manual
  3. A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts, 4th edition
  4. R. Ramakrishnan: Database Management Systems
  5. M. Varga: Baze podataka - konceptualno, logičko i fizičko modeliranje podataka
2. semester
Mandatory course - Mandatory studij - Computer Science and Mathematics
Consultations schedule: