PB154 Database Systems

Faculty of Informatics
Autumn 2026
Extent and Intensity
2/1/0. 3 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: z (credit).
In-person direct teaching
Teacher(s)
doc. RNDr. Jan Sedmidubský, Ph.D. (lecturer)
RNDr. Michal Batko, Ph.D. (seminar tutor)
doc. RNDr. Jan Sedmidubský, Ph.D. (seminar tutor)
Guaranteed by
doc. RNDr. Jan Sedmidubský, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: doc. RNDr. Jan Sedmidubský, Ph.D.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Prerequisites
!NOW( PB168 Introduction to DB and IS )
PB168 is a similar course designed primarily for career-oriented or multidisciplinary study in Computer Science.
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
there are 37 fields of study the course is directly associated with, display
Abstract
The goal of the course is to teach students principles of database systems.
Learning outcomes
On successful completion of the course the student will be able:
to formulate reasons for using database systems;
to understand basic principles of database systems;
to describe ways of indexing data;
to design a database schema;
to create queries for retrieving data.
Key topics
  • Introduction, terminology
  • Entity-relationship model
  • Relational model
  • Query language SQL
  • Integrity constraints
  • Relational database design
  • Storage and file structures
  • Indexing and hashing
  • Query processing
  • Transaction management
  • New trends in database systems
Study resources and literature
    recommended literature
  • SILBERSCHATZ, Abraham; Henry F. KORTH and S. SUDARSHAN. Database system concepts. 5th ed. Boston: McGraw-Hill, 2006, xxvi, 1142. ISBN 0072958863. info
Approaches, practices, and methods used in teaching
Lectures and seminars (lectures/seminars as well as teaching materials are in Czech). In seminars, selected parts of the lectures are exercised.
Method of verifying learning outcomes and course completion requirements
Lectures are given weekly. Seminars are given in a fortnight cycle. There are usually six seminars. Presence at seminars is not mandatory. To pass a course, one must first successfully pass a credit test verifying practical knowledge from the exercises and then successfully pass a final exam test verifying knowledge from the lectures. The final evaluation is the sum of the points for the credit test and the exam test.
Language of instruction
Czech
Follow-Up Courses
Further Comments
The course is taught annually.
The course is taught every week.
Listed among pre-requisites of other courses
The course is also listed under the following terms Autumn 2002, Autumn 2003, Autumn 2004, Autumn 2005, Autumn 2006, Autumn 2007, Autumn 2008, Autumn 2009, Autumn 2010, Autumn 2011, Autumn 2012, Autumn 2013, Autumn 2014, Autumn 2015, Autumn 2016, Autumn 2017, Autumn 2018, Autumn 2019, Autumn 2020, Autumn 2021, Autumn 2022, Autumn 2023, Autumn 2024, Autumn 2025.
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/fi/autumn2026/PB154