Database Systems and Management Information Systems
| Code | Completion | Credits | Range | Language |
|---|---|---|---|---|
| 128XDIS | Z | 1 | 1P+1C | Czech |
- Course guarantor:
- Jiří Kaiser
- Lecturer:
- Jiří Kaiser
- Tutor:
- Jiří Kaiser
- Supervisor:
- Department of Applied Informatics
- 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, results reporting using pivot charts and tables.
- Requirements:
-
No prerequisities
- Syllabus of lectures:
-
1. Explanation of keywords (data, information, knowledge, information system), Architectures of information systems
2. Analysis and design of transaction systems.
3. Data modeling using ER diagram, SQL - data types
4. SQL - database implementation
5. SQL - data retrieval
6. Management information systems, OLAP measures and dimensions, pivot tables and charts
- Syllabus of tutorials:
-
1 - 3 - Relational database design and implementation
4 - 7 - Data retrieval from databases, reporting using pivot charts and tables
- Study Objective:
-
Goal of the subject is to gain knowledge in branch of database systems and management information systems including data retriaval from transaction systems and results reporting using pivot charts and tables.
- 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. MySQL server documentation - http://dev.mysql.com
- Note:
- Further information:
- https://kix.fsv.cvut.cz/wiki/doku.php/bcmgr:128xdis
- Time-table for winter semester 2024/2025:
- Time-table is not available yet
- Time-table for summer semester 2024/2025:
- Time-table is not available yet
- The course is a part of the following study plans: