Poll

No polls currently selected on this page!

Repository

Repository is empty

Database systems

Code: 45672
ECTS: 5.0
Lecturers in charge: prof. dr. sc. Robert Manger
Lecturers: Helena Marciuš , mag. inf. et math. - Exercises
Hrvoje Olić , mag. math. - Exercises
English level:

1,0,0

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.
Load:

1. komponenta

Lecture typeTotal
Lectures 30
Exercises 15
* Load is given in academic hour (1 academic hour = 45 minutes)
Description:
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.

COURSE DESCRIPTION AND SYLLABUS:
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.
Literature:
2. semester
Mandatory course - Regular study - Mathematical Statistics
Consultations schedule:

Content

Link for the course web page: http://web.studenti.math.pmf.unizg.hr/~manger/bp/