B_DAS Database systems

Institute of Technology and Business in České Budějovice
winter 2025
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.
Department of Applied Technologies and Materials Research – Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice
Supplier department: Department of Applied Technologies and Materials Research – Faculty of Technology – Rector – Institute of Technology and Business in České Budějovice
Timetable of Seminar Groups
B_DAS/P01: Thu 8:00–8:45 I102, R. Frischer, I. Špička
B_DAS/S01: Thu 8:45–9:30 I102, R. Frischer, I. Špička
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.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vstecb.cz/course/vste/winter2025/B_DAS