FI:PB154 Database Systems - Course Information

PB154 Database Systems

Extent and Intensity

2/0. 2 credit(s) (plus extra credits for completion). Type of Completion: zk (examination).

Teacher(s)

prof. Ing. Pavel Zezula, CSc. (lecturer)

Guaranteed by

prof. Ing. Pavel Zezula, CSc.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: prof. Ing. Pavel Zezula, CSc.

Timetable

Thu 10:00–11:50 D1

Prerequisites (in Czech)

! P002 Introduction to Database Systems &&! P502 Introduction to Database Systems

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

• Informatics (programme FI, B-IN)
• Mathematics for Multi-Branches Study (programme PřF, B-MA)
• Mathematics (programme PřF, B-MA)
• Mathematics (programme PřF, B-MA)
• Profesional Mathematics (programme PřF, B-MA)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-SS)

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.

Language of instruction

Czech

Further Comments

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)  

• Enrolment Statistics (Autumn 2002, recent)
  
• Permalink: https://is.muni.cz/course/fi/autumn2002/PB154