Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2020/2021

Systems Engineering and Information Systems

The course is not on the list Without time-table
Code Completion Credits Range Language
51XSI KZ 4 1P+2C Czech
Lecturer:
Tutor:
Supervisor:
Institute of Pedagogical and Psychological Studies
Synopsis:

Design of primary system database, database implementation using SQL, data retrieval from transaction systems and data processing, OLAP measures and dimensions design and implementation for decision making purposes and results reporting using pivot charts and tables.

Requirements:

seminar projects, test

Syllabus of lectures:

1. Explanation of keywords, architectures of information systems

2. Management information systems

3. Analysis and design of transaction systems, data modeling using ER diagram,

4. Data model normalization and SQL data types

5. SQL - database implementation

6. SQL - data retrieval and reporting

7. System theory and data processing methods

Syllabus of tutorials:

1 - 3 - Reporting using pivot charts and tables

4 - 7 - Relational database design and implementation

8 - 13 - Data retrieval from databases, data processing and reporting.

Study Objective:

Goal of the subject is to gain knowledge in branch of information systems and systems engineering with focus on management information systems including data retriaval from transaction systems.

Study materials:

1. MOLNÁR, Zdeněk. Podnikové informační systémy. Vyd. 2., přeprac. V Praze: České vysoké učení technické, 2009, 195 s. ISBN 978-80-01-04380-6.

2. KANISOVÁ, Hana a Miroslav MÜLLER. UML srozumitelně. 2. aktualiz. vyd. Brno: Computer Press, 2006, 176 s. ISBN 80-251-1083-4.

3. ARLOW, Jim a Ila NEUSTADT. UML 2 a unifikovaný proces vývoje aplikací: objektově orientovaná analýza a návrh prakticky. Vyd. 1. Překlad Bogdan Kiszka. Brno: Computer Press, 2007, 567 s. ISBN 978-80-251-1503-9.

4. PETR, Jan. Projektování systémů: Určeno pro stud. fak. stavební. 1. vyd. Praha: ČVUT, 1990, 177 s. ISBN 80-010-0460-0.

5. KANTARDZIC, Mehmed. Data mining: concepts, models, methods, and algorithms. Hoboken, NJ: IEEE Press, 2003, xii, 345 p. ISBN 04-712-2852-4.

6. MySQL server documentation - http://dev.mysql.com

Note:
Further information:
není
No time-table has been prepared for this course
The course is a part of the following study plans:
Data valid to 2020-09-25
For updated information see http://bilakniha.cvut.cz/en/predmet2339006.html