Course detail

Data and Functional Modelling

FP-DFMAcad. year: 2024/2025

Learning outcomes of the course unit. The course provides students with basic knowledge and skills in the field of data, functional and process modeling, which are essential for business analysis and creation of information systems. Data models. Relational data model. Relational algebra. SQL Language. Normalization of relational models. Functional modeling. Verbal description of the model. Data Flow Diagram. Flowchart. State diagram. Context diagram. Process diagram. UML language. Conceptual model.

Language of instruction

Czech

Number of ECTS credits

6

Mode of study

Not applicable.

Entry knowledge

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

Rules for evaluation and completion of the course

Two semestral works are required for granting the credit. The work will be evaluated 0-10 points, to get the credit is necessary evaluation not less than 12 points from both projects. The work must be submitted in the credit week.

Examination Requirements: Knowledge of the subject matter and its practical application.
Form of examination - written and oral. In the written part the students solve the given examples, in the oral part the knowledge of the theory is verified.

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.

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.
Students will be able to 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.

Study aids

E-learning serves as a study support, where lectures and supporting materials are displayed.

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

  • Programme BAK-MIn Bachelor's 1 year of study, winter semester, compulsory

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

Syllabus

1. Introduction
2 Data models, functional models, process models
3 Relational data model. Basic principles and techniques.
4 Relational notation modeling, modeling
5 Relational Algebra. SQL language for database management - basic commands
6 Normalizing Relational Models. The first three basic forms, the three additional forms
7 Process modeling. EPC diagram, RACI matrix, process control
8 Functional Modeling. Concepts, procedures.
9 Word description of the model. Model creation.
10 Data Flow Diagram Data Flow in Processes and Functions
11 UML. Basics of modeling language
12 Object Modeling. Basic concepts, object and work with it, methods
13 Summary

Exercise

26 hod., compulsory

Teacher / Lecturer

Syllabus

1-4 Data Modeling

5-8 Functional Modeling

9-11 Process Modeling

12 Project Presentations

13 Assessment

Elearning