FI:PB154 Database Systems - Course Information
PB154 Database SystemsFaculty of Informatics
- Extent and Intensity
- 2/1. 3 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: z (credit).
- prof. Ing. Pavel Zezula, CSc. (lecturer), doc. RNDr. Vlastislav Dohnal, Ph.D. (deputy)
doc. RNDr. Vlastislav Dohnal, Ph.D. (seminar tutor)
RNDr. Jan Sedmidubský, Ph.D. (seminar tutor)
RNDr. Petra Budíková, Ph.D. (seminar tutor)
RNDr. Jakub Valčík (seminar tutor)
RNDr. Tomáš Homola, Ph.D. (seminar tutor)
doc. RNDr. Vlastislav Dohnal, Ph.D. (assistant)
RNDr. Michal Batko, Ph.D. (assistant)
Bc. Marek Bednařík (assistant)
- Guaranteed by
- prof. RNDr. Luděk Matyska, CSc.
Department of Computer Systems and Communications - Faculty of Informatics
Contact Person: prof. Ing. Pavel Zezula, CSc.
Supplier department: Department of Computer Systems and Communications - Faculty of Informatics
- Mon 12:00–13:50 D1, Mon 12:00–13:50 D2
- Timetable of Seminar Groups:
PB154/T02: Mon 16:00–17:55 Učebna S6 (20), J. Valčík
PB154/T03: Thu 4. 10. to Fri 21. 12. each even Thursday 10:00–11:55 Učebna S4 (35a), T. Homola
PB154/01: each even Thursday 8:00–9:50 G126, V. Dohnal
PB154/02: each odd Thursday 8:00–9:50 G126, V. Dohnal
PB154/03: each even Friday 8:00–9:50 C525, V. Dohnal
PB154/04: each odd Friday 8:00–9:50 C525, V. Dohnal
PB154/05: each even Friday 8:00–9:50 C511, P. Budíková
PB154/06: each odd Friday 8:00–9:50 C511, P. Budíková
PB154/07: each even Thursday 8:00–9:50 C525, J. Sedmidubský
PB154/08: each odd Thursday 8:00–9:50 C525, J. Sedmidubský
PB154/09: each even Thursday 10:00–11:50 C525, J. Sedmidubský
PB154/10: each odd Thursday 10:00–11:50 C525, J. Sedmidubský
PB154/11: each even Thursday 18:00–19:50 C525, J. Valčík
PB154/12: each odd Thursday 18:00–19:50 C525, J. Valčík
- 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
- there are 25 fields of study the course is directly associated with, display
- Course objectives
- The goal of the course is to teach students principles of database systems.
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 retriving data.
- 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
- 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
- Follow-Up Courses
- Further Comments
- Study Materials
The course is taught annually.
- Listed among pre-requisites of other courses