Czech

Not applicable.

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.

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

Not applicable.

Lectures consist of an explanation of basic principles, methodology of the discipline, problems and their solutions. E-learning.

Conditions for awarding the course-unit credit:
1. Active participation in exercises will be controlled and assessed by the teacher – 1 point/lesson
2. Two semestral work, max 10 point / project

Total number of points for awarding the course-unit credit has to be higher or equal than 20 points, as a minimum 5 lessons / 5 first /5 second semestral work.

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

Topics of lectures are the following:
- Basic techniques of data storage in computers
- Data models
- Relational data model
- Relation models entry notation.
- Relational algebra. SQL language.
- Relation models normalization
- MS Access database system
- Functional modelling
- Verbal description of model
- Data Flow Diagram
- Flow diagram
- State diagram
- Context diagram
- Process diagram
The seminars are focused on practising of the lectured topics and elaboration of case studies (both individually and in teams).

Not applicable.

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.

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.

Not applicable.

Not applicable.

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)

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)