B_DAS Database systems

Institute of Technology and Business in České Budějovice
winter 2026
Extent and Intensity
1/1. 2 credit(s). Type of Completion: zk (examination).
Teacher(s)
doc. Ing. Robert Frischer, Ph.D. (seminar tutor)
doc. Ing. Ivo Špička, Ph.D. (seminar tutor)
Guaranteed by
doc. Ing. Ivo Špička, Ph.D.
Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice
Supplier department: Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives supported by learning outcomes
The aim of the course is to introduce students to the basic concepts of database technologies: relational data model, functional The graduates will learn about the conceptual model of a database and the basics of the SQL standard. and the relational schema.
Learning outcomes
The student is able to describe database technologies, can create a relational data model, functional dependencies, normal forms databases. Graduates of the course will be able to define a conceptual model of a database, relational schema. Core skills The student's main skill is to master the basic constructs of the SQL language according to the standard.
Syllabus
  • 1. Introduction to database technologies. Motivation, data independence and DBMS architecture. Relational data model.
  • 2. Relational algebra. Basic operations.
  • 3. SQL standards (especially SQL 92), introduction to Select querying (basic commands, joins).
  • 4. SQL Select - Nested Select queries.
  • 5. SQL Select - Inner and outer joins, aggregation functions and clustering.
  • 6. Conceptual Modeling. Entities, entity types, constraints, integrity constraints.
  • 7. ER diagram, UML class diagram. Conversion of conceptual model to data model.
  • 8. SQL - data modification language (JMD) and data definition language (JDD); Data types.
  • 9. Functional and dynamic analysis of IS.
  • 10. Functional dependencies.
  • 11. Normal forms and relational database schema design in BCNF.
  • 12. Overview of existing DBMSs.
  • 13. Overview and comparison of existing DBMSs.
Literature
    required literature
  • H. GARCIA-MOLINA, J. D. ULLMAN, J. D. WIDOM, 2001. Database Systems: The Complete Book. Prentice Hall.
  • POKORNÝ, J. a M. VALENTA, 2020. Databázové systémy. 2. přepracované vydání. Praha: Česká technika - nakladatelství ČVUT. ISBN 978-80-01-06696-6.
    recommended literature
  • LING, L. a M. TAMER ÖZSU (ed.), 2009. Encyclopedia of Database Systems. Springer New York. ISBN 978-0-387- 39940-9
  • M. KRÁTKÝ, R. BAČA. 2009. Databázové systémy.
Forms of Teaching
Lecture
Seminar
Student Workload
ActivitiesNumber of Hours of Study Workload
Daily StudyCombined Study
Attendance on Lectures13 
Attendance on Seminars/Exercises/Tutorial/Excursion13 
Total:260
Assessment Methods and Assesment Rate
Test – mid-term 30 %
Test – final 70 %
Seminary Work 30 %
Exam conditions
To successfully complete the course, it is necessary to achieve the sum of the continuous and final assessment of at least 70% under the conditions set out below. V 30 points can be obtained in the continuous assessment, i.e. 30%. In the final assessment, it is possible to a total of 70 points, i.e. 70 %. Průběžné hodnocení: Semestrální práce/ Průběžný test (30 bodů)
Závěrečné hodnocení : Závěrečný test (70 bodů)
Language of instruction
Czech
Teacher's information
A full-time student is obliged to attend contact classes, i.e. everything except lectures, to meet the mandatory 70% attendance. A 100 – 90, B 89.99 – 84, C 83.99 – 77, D 76.99 – 73, E 72.99 – 70, FX 69.99 – 30, F 29.99 – 0.
The course is also listed under the following terms winter 2025.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vstecb.cz/course/vste/winter2026/B_DAS