FI:PV063 Database System Applications - Course Information

PV063 Database System Applications

Extent and Intensity

2/1. 3 credit(s) (plus extra credits for completion). Recommended Type of Completion: zk (examination). Other types of completion: k (colloquium), z (credit).

Teacher(s)

RNDr. Pavel Hajn (lecturer)

Guaranteed by

doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: RNDr. Pavel Hajn
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics

Timetable

Thu 16:00–17:50 G123

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)
• Applied Informatics (programme FI, N-AP)
• Information Technology Security (programme FI, N-IN)
• Bioinformatics (programme FI, B-AP)
• Bioinformatics (programme FI, N-AP)
• Information Systems (programme FI, N-IN)
• Informatics with another discipline (programme FI, B-BI)
• Informatics with another discipline (programme FI, B-EB)
• 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)
• Informatics (programme FI, M-IN)
• Informatics (programme FI, N-IN)
• Public Administration Informatics (programme FI, B-AP)
• Mathematical Informatics (programme FI, B-IN)
• Parallel and Distributed Systems (programme FI, B-IN)
• Parallel and Distributed Systems (programme FI, N-IN)
• Computer Graphics and Image Processing (programme FI, B-IN)
• Computer Graphics (programme FI, N-IN)
• Computer Networks and Communication (programme FI, B-IN)
• Computer Networks and Communication (programme FI, N-IN)
• Computer Systems and Data Processing (programme FI, B-IN)
• Computer Systems (programme FI, N-IN)
• Embedded Systems (eng.) (programme FI, N-IN)
• Programmable Technical Structures (programme FI, B-IN)
• Embedded Systems (programme FI, N-IN)
• Service Science, Management and Engineering (eng.) (programme FI, N-AP)
• Service Science, Management and Engineering (programme FI, N-AP)
• Social Informatics (programme FI, B-AP)
• Theoretical Informatics (programme FI, N-IN)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-IN)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-SS)
• Upper Secondary School Teacher Training in Informatics (programme FI, M-TV)
• Upper Secondary School Teacher Training in Informatics (programme FI, N-SS) (2)
• Artificial Intelligence and Natural Language Processing (programme FI, B-IN)
• Artificial Intelligence and Natural Language Processing (programme FI, N-IN)
• Information Technology (programme FI, B-IN)
• Image Processing (programme FI, N-AP)

Course objectives

The goal of the course is to teach students the principles of information systems and using databases for creation IS.

Syllabus

• What is an information system and a DBS?
• Transactional and OLAP database.
• Tools for IS creation.
• Modern information systems.
• The IS lifetime -- analysis, design, implementation, establishing, running, reanalysis and modernization.
• Design of operative IS.

Literature

• Sylaby přednášek
• LACKO, Ľuboslav. Databáze : datové sklady, OLAP a dolování dat s příklady v Microsoft SQL Serveru a Oracle. Vyd. 1. Brno: Computer Press, 2003, 486 s. ISBN 8072269690. info
• KRÁL, Jaroslav. Informační systémy :specifikace, realizace, provoz. 1. vyd. Veletiny: Science, 1998, 358 s. ISBN 80-86083-00-4. info
• SMITH, Stephen J. and Aleksandr Semenovič BERSON. Data warehousing, data mining, and OLAP. New York: McGraw-Hill, 1997, xxvi, 612. ISBN 0070062722. info
• POKORNÝ, Jaroslav. Databázové systémy a jejich použití v informačních systémech. 1. vyd. Praha: Academia, 1992, 313 s. ISBN 8020001778. info

Teaching methods

theoretical lectures and practical previews

Assessment methods

Course with practicle prezentation of information systems. Written test - concept part of the information system.

Language of instruction

Czech

Further Comments

Study Materials
The course is taught annually.

• Enrolment Statistics (Spring 2013, recent)
  
• Permalink: https://is.muni.cz/course/fi/spring2013/PV063