Systems Engineering and Information Systems

Course guarantor:

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:

• B-EK-prez.forma od 10/11 (compulsory elective course)
• B-EK-prez.forma od 11/12 (compulsory elective course)
• B-EK-prez.forma od 12/13 (compulsory elective course)
• B-EK-prez.forma od 13/14 (compulsory elective course)
• B-EK-prez.forma od 14/15 (compulsory elective course)