PB155 Database systems and their applications

Faculty of Informatics
Autumn 2006
Extent and Intensity
2/0. 2 credit(s) (plus extra credits for completion). Type of Completion: zk (examination).
Teacher(s)
RNDr. Pavel Hajn (lecturer)
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
Thu 18:00–19:50 D3
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
there are 16 fields of study the course is directly associated with, display
Course objectives
The goal of the course is to teach students the principles of database systems and their applications.
Syllabus
  • Basic terms, database, entity, attributes. Database schema,logical, physical. Database models hierarchical, network, relational (relational schema). Data definition language. Data manipulation language. Query languages, relational algebra, relational calculus (domain, tuple). SQL standards, application in database systems. Data definition design, functional dependencies, keys, Armstrong axioms, normal forms. Implementation of database systems, transaction processing, replication and distributed databases. Commercial database products. Information systems and database systems. The role of databases in information systems. Homogeneous and heterogeneous database environments. Database access technology. Databases and management. Text and document databases. Data warehouses and multidimensional databases.
Literature
  • Jaroslav Pokorný: Databázová abeceda, SCIENCE 1998
  • Jaroslav Pokorný: Databázové systémy a jejich použití v informačních systémech, ACADEMIA, 1992
  • Ullman J.D., Principles of Database Systems,Computer Science Press, 1983
  • KRÁL, Jaroslav. Informační systémy :specifikace, realizace, provoz. 1. vyd. Veletiny: Science, 1998, 358 s. ISBN 80-86083-00-4. info
  • STRAKA, Miroslav. Vývoj databázových aplikací. Praha: Grada, 1992, 129 s. ISBN 80-85424-43-6. info
Assessment methods (in Czech)
Přednáška s doplňujícími informacemi. Příklady řešené přednášejícím. Zkouška písemná - základní teoretické znalosti a řešení příkladů odpovídajících přednášce. Obsah zkoušky 3 testovavcí okruhy (oblasti: návrh struktury databáze, SQL, základní teoretické znalosti) celkové hodnocení 15 bodů, prospěl 8 a více bodů.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2002, Autumn 2003, Autumn 2004, Autumn 2005, Autumn 2007, Autumn 2008.
  • Enrolment Statistics (Autumn 2006, recent)
  • Permalink: https://is.muni.cz/course/fi/autumn2006/PB155