PB154 Database Systems

Faculty of Informatics
Autumn 2021
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).
Teacher(s)
prof. Ing. Pavel Zezula, CSc. (lecturer), doc. RNDr. Vlastislav Dohnal, Ph.D. (deputy)
RNDr. Michal Batko, Ph.D. (seminar tutor)
RNDr. Petra Budíková, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Petr Eliáš, Ph.D. (seminar tutor)
RNDr. Miriama Jánošová (seminar tutor)
RNDr. Vladimír Míč, Ph.D. (seminar tutor)
RNDr. Jakub Peschel (seminar tutor)
doc. RNDr. Jan Sedmidubský, Ph.D. (seminar tutor)
Mgr. Ing. Tomáš Svoboda (assistant)
Guaranteed by
prof. Ing. Pavel Zezula, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: prof. Ing. Pavel Zezula, CSc.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Timetable
Mon 13. 9. to Mon 6. 12. Mon 14:00–15:50 Virtuální místnost
  • Timetable of Seminar Groups:
PB154/01: Fri 24. 9. to Fri 3. 12. each even Friday 10:00–11:50 B410, M. Batko
PB154/02: Fri 17. 9. to Fri 10. 12. each odd Friday 10:00–11:50 B410, M. Batko
PB154/03: Fri 24. 9. to Fri 3. 12. each even Friday 8:00–9:50 B410, P. Budíková
PB154/04: Fri 17. 9. to Fri 10. 12. each odd Friday 8:00–9:50 B410, P. Budíková
PB154/05: Wed 22. 9. to Wed 1. 12. each even Wednesday 10:00–11:50 A319, M. Batko
PB154/06: Wed 15. 9. to Wed 8. 12. each odd Wednesday 10:00–11:50 A319, M. Batko
PB154/07: Wed 22. 9. to Wed 1. 12. each even Wednesday 8:00–9:50 B410, M. Batko
PB154/08: Wed 15. 9. to Wed 8. 12. each odd Wednesday 8:00–9:50 B410, M. Batko
PB154/09: Wed 22. 9. to Wed 1. 12. each even Wednesday 12:00–13:50 A218, J. Sedmidubský
PB154/10: Wed 15. 9. to Wed 8. 12. each odd Wednesday 12:00–13:50 A218, J. Sedmidubský
PB154/11: Wed 22. 9. to Wed 1. 12. each even Wednesday 14:00–15:50 A218, J. Sedmidubský
PB154/12: Wed 15. 9. to Wed 8. 12. each odd Wednesday 14:00–15:50 A218, V. Míč
PB154/13: Tue 21. 9. to Tue 30. 11. each even Tuesday 16:00–17:50 A218, V. Míč
PB154/14: Tue 14. 9. to Tue 7. 12. each odd Tuesday 16:00–17:50 A218, V. Míč
PB154/15: Tue 21. 9. to Tue 30. 11. each even Tuesday 10:00–11:50 B410, M. Batko
PB154/16: Tue 14. 9. to Tue 7. 12. each odd Tuesday 10:00–11:50 B410, M. Batko
PB154/17: Fri 24. 9. to Fri 3. 12. each even Friday 10:00–11:50 B204, V. Dohnal
PB154/18: Fri 17. 9. to Fri 10. 12. each odd Friday 10:00–11:50 B204, V. Dohnal
PB154/19: Tue 21. 9. to Tue 30. 11. each even Tuesday 14:00–15:50 B410, M. Jánošová
PB154/20: Tue 14. 9. to Tue 7. 12. each odd Tuesday 14:00–15:50 B410, M. Jánošová
Prerequisites
Ability to understend a computer-specialized English text.
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
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.
Syllabus
  • 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
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
Teaching methods
Lectures and seminars. Lectures are given in Czech, but teaching materials are in English. In seminars, materials in Czech are used exclusively. Selected parts of the lecture are exercised in seminars.
Assessment methods
Lectures are given weekly. Seminars are given in a fortnight cycle. There are usually five seminars plus consultation. Presence at seminars is not mandatory. The course is completed with a written exam consisting of ten tasks. Each task is graded with 6 points at maximum. The minimum of 30 points is required to pass the exam. Before sitting for the exam, the student must pass a credit test. It contains eight tasks in each a correct answer out of four options must be selected. A correct answer is graded with +3 points and an incorrect answer is graded with -1 point. The minimum to pass the test is 10 points.
Language of instruction
Czech
Follow-Up Courses
Further Comments
Study Materials
The course is taught annually.
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 2022, Autumn 2023, Autumn 2024.
  • Enrolment Statistics (Autumn 2021, recent)
  • Permalink: https://is.muni.cz/course/fi/autumn2021/PB154