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

Wed 18:00–19:50 D1

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 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

Course with examples. Written test with the 3 areas (databese schema, SQL, basic theoretical knowledges).

Language of instruction

Czech

Further Comments

Study Materials
The course is taught annually.

• Enrolment Statistics (recent)
  
• Permalink: https://is.muni.cz/course/fi/autumn2008/PB155