1. komponenta

Lecture type	Total
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.

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.

Mandatory course - Regular study - Mathematical Statistics