Course: Database Systems

» List of faculties » FM » MTI
Course title Database Systems
Course code MTI/RDB
Organizational form of instruction Lecture + Lesson
Level of course Master
Year of study not specified
Semester Summer
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory, Compulsory-optional
Form of instruction Face-to-face
Work placements Course does not contain work placement
Recommended optional programme components None
Lecturer(s)
  • Tyl Pavel, Ing.
  • Špánek Roman, Ing. Ph.D.
  • Vitvarová Jana, Ing. Ph.D.
Course content
The subject deals with the theory of the relational data mode, normal forms, principles of the SQL, algorithms of relational database schema design, normal forms. Principles of the client-server technology, description of SQL language and its practical applications. Processing queries in a network environment, optimisation of SQL query evaluation.

Learning activities and teaching methods
Monological explanation (lecture, presentation,briefing), Working activities (workshops)
  • Class attendance - 56 hours per semester
Learning outcomes
The course aims at data and functional analysis and creation of information systems based on databases. For the analysis Case systems are used. Normalization as a basic measure of quality of database schema is discussed in details. Relational algebra - the predecessor of SQL language is also introduced. SQL language is used for realization of the modeled reality on server site. Server site security issues and advanced topics connected with transactions management are also given.
Students will acquire further knowledge in database systems. Algorithms are focused on maintaining server site, maintaining disk files, database methods.
Prerequisites
Basic knowledge of databases systems. Programming ability in an object programming language (java, C#)

Assessment methods and criteria
Combined examination, Oral exam

Recommended literature
  • Šešera L. a kol. Datové modelování v příkladech. Grada.
  • Doucek P. Řízení projektů informačních systémů. Professional Publishing, 2004.
  • Forrest Houlette. SQL - příručka programátora. SoftPress, 2000.
  • Kraval I. Objektové modelování pomocí UML v praxi, e-kniha, možnost získat na <a href="http://www.objects.cz/">http://www.objects.cz/</a>. 2005.
  • Pokorný J. Databázová abeceda. Science, 1998.
  • Pokorný J. Počítačové databáze, Výběr informací z organizační a výpočetní techniky. KS Praha, 1991.
  • Šimůnek P. SQL - kompletní kapesní průvodce. Grada, 1999.
  • Ullman L. PHP pokročilé programování pro WWW. SoftPress, 2005.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Mechatronics, Informatics and Interdisciplinary Studies Study plan (Version): Information Technology (2013) Category: Informatics courses 1 Recommended year of study:1, Recommended semester: Summer
Faculty: Faculty of Mechatronics, Informatics and Interdisciplinary Studies Study plan (Version): Automatic Control and Applied Computer Science (2016) Category: Special and interdisciplinary fields 1 Recommended year of study:1, Recommended semester: Summer