Database Systems

Course Code:
Academic Degree:
Study Programme:
Technology in Transportation and Telecommunications (B 3710)
semesterlanguagestudy field / specialization
3czech, englishcommon part of studies
Form of Study:
full-time and part-time
Number of Hours:
1 + 1 hours per week - in full-time study
10 hours per semester - in part-time study
Type of Course:
Course Completion:
classified credit
Course Tutor:
roh  Lectures:
Ing. Ondřej Smíšek
Ing. Martin Šrotýř, Ph.D.
roh  Training Course:
Ing. Jana Kaliková, Ph.D.
Ing. Jan Krčál, Ph.D.
Ing. Ondřej Smíšek
Ing. Martin Šrotýř, Ph.D.
roh  Part-time Study:
Ing. Ondřej Smíšek
Supervising Department:
Department of Applied Informatics in Transportation (16114)
relational data model, candidate key, foreign key, database normalization, data integrity, relational database, SQL query language, architectures of database systems
Basic concepts of database systems, conceptual model, relational data model, the principles of normal forms, relational database design, security and integrity of data, database queries, relational algebra, SQL language, client / server, multilayer architectures, distributed database systems. Access to data via the WWW.
Fundamentals of relational database theory, practical skills in using database technology at a level required for database design and creation of queries to the database. Introduction to database administration, architectures of database systems, trends in database technologies.