Database Systems

Course Code:
14DATS
Academic Degree:
bachelor
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
Credits:
2
Number of Hours:
1 + 1 hours per week - in full-time study
10 hours per semester - in part-time study
Type of Course:
obligatory
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)
Keywords:
relational data model, candidate key, foreign key, database normalization, data integrity, relational database, SQL query language, architectures of database systems
Abstract:
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.
Objectives:
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.