FI:PB154 Database Systems - Course Information
PB154 Database Systems
Faculty of InformaticsAutumn 2007
- Extent and Intensity
- 2/1. 3 credit(s) (plus extra credits for completion). Type of Completion: zk (examination).
- Teacher(s)
- prof. Ing. Pavel Zezula, CSc. (lecturer)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
RNDr. Stanislav Bartoň, Ph.D. (seminar tutor)
doc. RNDr. Jan Sedmidubský, Ph.D. (seminar tutor) - Guaranteed by
- prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: prof. Ing. Pavel Zezula, CSc. - Timetable
- Mon 16:00–17:50 D1
- Timetable of Seminar Groups:
PB154/02: each even Monday 12:00–13:50 B011, S. Bartoň
PB154/03: each odd Monday 14:00–15:50 B011, V. Dohnal
PB154/04: each even Monday 14:00–15:50 B011, V. Dohnal
PB154/05: each odd Tuesday 12:00–13:50 B410, V. Dohnal
PB154/06: each even Tuesday 12:00–13:50 B410, V. Dohnal
PB154/07: each odd Friday 9:00–10:50 B011, V. Dohnal
PB154/08: each even Friday 9:00–10:50 B011, V. Dohnal
PB154/09: each odd Friday 11:00–12:50 B011, V. Dohnal
PB154/10: each even Friday 11:00–12:50 B011, V. Dohnal
PB154/11: No timetable has been entered into IS. J. Sedmidubský - 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
- Applied Informatics (programme FI, B-AP)
- Bioinformatics (programme FI, B-AP)
- Economic Information Systems (programme ESF, B-SI)
- Informatics with another discipline (programme FI, B-BI)
- Informatics with another discipline (programme FI, B-FY)
- Informatics with another discipline (programme FI, B-GE)
- Informatics with another discipline (programme FI, B-GK)
- Informatics with another discipline (programme FI, B-CH)
- Informatics with another discipline (programme FI, B-IO)
- Informatics with another discipline (programme FI, B-MA)
- Informatics with another discipline (programme FI, B-SO)
- Informatics with another discipline (programme FI, B-TV)
- Informatics (programme FI, B-IN)
- Mathematical Informatics (programme FI, B-IN)
- Mathematics for Multi-Branches Study (programme PřF, B-MA)
- Mathematics with Informatics (programme PřF, N-MA)
- Mathematics (programme PřF, B-MA)
- Parallel and Distributed Systems (programme FI, B-IN)
- Lower Secondary School Teacher Training in Technology and IT Education (programme PdF, B-SPE)
- Computer Graphics and Image Processing (programme FI, B-IN)
- Computer Networks and Communication (programme FI, B-IN)
- Computer Systems and Data Processing (programme FI, B-IN)
- Profesional Mathematics (programme PřF, B-MA)
- Programmable Technical Structures (programme FI, B-IN)
- Upper Secondary School Teacher Training in Informatics (programme FI, M-SS)
- Upper Secondary School Teacher Training in Informatics (programme FI, M-TV)
- Artificial Intelligence and Natural Language Processing (programme FI, B-IN)
- Course objectives
- The goal of the course is to teach students principles of database systems and design methods for developing database applications.
- Syllabus
- Introduction; Entity-Relationship model; relational model; query language SQL; integrity constraints; relational database design; object-oriented databases; storage and file structures; indexing and hashing; query processing; transaction management; concurrency control; recovery system; new trends in database systems.
- Literature
- A. Silberschatz, H.F. Korth, and S. Sudarshan. Database System Concepts (third edition), McGraw-Hill, 1998, ISBN: 0-07-031086-6.
- Assessment methods (in Czech)
- Přednášky a cvičení. Zakončení písemnou zkouškou.
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- Study Materials
The course is taught annually. - Listed among pre-requisites of other courses
- PA195 NoSQL Databases
PB154 || PB168 - PB168 Introduction to DB and IS
!PB154 && !NOW(PB154)
- PA195 NoSQL Databases
- Teacher's information
- http://www.fi.muni.cz/~zezula/lectures/PB154/
- Enrolment Statistics (Autumn 2007, recent)
- Permalink: https://is.muni.cz/course/fi/autumn2007/PB154