FI:PB155 Database Systems Applications - Course Information

PB155 Database systems and their applications

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

• Applied Informatics (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)
• 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)

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.

• Enrolment Statistics (Autumn 2005, recent)
  
• Permalink: https://is.muni.cz/course/fi/autumn2005/PB155