Course detail

Data and Functional Modelling

FP-MdfmKAcad. year: 2019/2020

The course focuses especially on the following topics: Fundamental techniques of data storage in computers. Data models. Relational data model. Relation models entry notation. Relation algebra. SQL language. Relational models normalization. MS Access database system. Functional modelling. Verbal description of the model. Data Flow Diagram. Flow diagram. Status diagram. Context diagram. Process diagram. Conceptual model.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Learning outcomes of the course unit

Students will be able analyse the entrepreneurial processes. They will be able to design optimal relation data models and to define correctly integrity limitations of the model with respect to the analyzed processes. They will be able to design functional models of these processes, and to process documentation of analysed processes according to different conventions.

Prerequisites

Knowledge of mathematical sets, basic operations with sets, entry conventions. Secondary school knowledge is sufficient.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

The course contains lectures that explain basic principles, problems and methodology of the discipline, and exercises that promote the practical knowledge of the subject presented in the lectures. E-learning support.

Assesment methods and criteria linked to learning outcomes

Conditions for awarding the course-unit credit: 12 points

1. Active participation in exercises
2. Two assignments - max 10 point/assignment
Min. 12 point requiered for credits

Conditions for passing an exam: Knowledge of taught topics and its practical application
Form of examination: Combined – written test and oral examination.

Course curriculum

1 Úvod
2 Datové modely, funkční modely, procesní modely
3 Relační datový model. Základní principy a techniky.
4 Notace zápisu relačních modelů, vytváření modelů
5 Relační algebra. Jazyk SQL pro práci s databázovým systémem - základní příkazy
6 Normalizace relačních modelů. První tři základní formy, tři doplňkové formy
7 Procesní modelování. EPC diagram, RACI matice, procesní řízení
8 Funkční modelování. Pojmy, postupy.
9 Slovní popis modelu. Vytváření modelů.
10 Data Flow Diagram Tok dat v procesech a funkcních
11 UML. Základy modelovacího jazyka
12 Objektové modelování. Základní pojmy, objekt a práce s ním, metody
13 Shrnutí

Work placements

Not applicable.

Aims

The main objective of the course is to provide students with the necessary knowledge and especially practical skills necessary for the analysis of corporate processes with respect to data and function models as a basic instrument for the IS creation. It is also necessary to understand fundamentals of formation of relation data models, relation algebra, data normalization and integrity limits definition. To identify and learn how to use basic relation models entry notations. It is necessary to master fundamental methods of functional models identification and to know how to analyze and realize corporate processes by means of these methods. To integrate data and functional model into a conceptual model.

Specification of controlled education, way of implementation and compensation for absences

Control of results of independent work on specified tasks. In case of excused absence from seminars, the teacher can set an additional condition, if appropriate, usually elaboration of a partial written task.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

KOCH, M.; NEUWIRTH, B. Datové a funkční modelování. Datové a funkční modelování. Brno, Cerm. 2010. (139 p.). ISBN 978-80-214-4125-5. (CS)

Recommended reading

PÍSEK,S.: Access 2003. Praha: Grada, 2005, 224s. ISBN 80-247-0788-8 (CS)
RIORDAN, Rebecca M.: Vytváříme relační databázové aplikace. Praha : Computer Press, 2000. 280 s. ISBN 80-7226-360-9 (CS)
STEPHENS,R. PLEW,R.: Naučte se SQL za 21 dní. Praha: Computer Press, 2004, 584s., ISBN: 80-722-6870-8 (CS)

eLearning

Classification of course in study plans

Type of course unit

 

Guided consultation in combined form of studies

20 hours, optionally

Teacher / Lecturer

eLearning