The course is offered on the fifth term of the Bachelor's programme in Design of Information Systems, to exchange students and as a freestanding course.

Course description

The course presupposes a basic knowledge of conceptual modelling for data base systems and implementation using relational DBMS and SQL. The course aims to a more profound understanding of database theories, models, and methods and an ability to use these in different situations.

Course content:

• Database systems concepts and architecture
• Concepts used in UML, EER, and XML.
• Transformation of conceptual models to a relation. Properties of normalisation up to 4NF.
• Views, implementation of integrity constraints.
• Centralised, decentralised and distributed databases.
• Transaction handling. Concurrency and recovery. Query optimization. Advanced and embedded SQL. Triggers and stored procedures.
• The problem of using different architectures in client and server side applications.
• Techniques for efficient storing, accessing, securing, and recovering of data.
• Implementation of advanced structures in relational, hybrid, and object oriented data bases.
• Techniques for distributed data bases.

Teaching methods and examination: Lectures, lessons, laboratory work. Written test and assignments.