Poll

No polls currently selected on this page!

Repository

Repository is empty

Database systems

Code: 45548
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:

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:
  1. C. J. Date: An Introduction to Database Systems, 7th edition
  2. A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts, 4th edition
  3. R. Ramakrishnan: Database Management Systems
  4. M. Widenius, D. Axmark: MySQL Reference Manual
  5. M. Varga: Baze podataka - konceptualno, logičko i fizičko modeliranje podataka
Prerequisit for:
Enrollment :
Passed : Data structures and algorithms
3. semester
Izborni modul Računarstvo - Regular study - Mathematics

4. semester
Izborni modul Računarstvo - Regular study - Mathematics
Consultations schedule:

Content

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