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

Information Systems and Database Systems

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
128IDBS Z,ZK 6 2P+3C English
Lecturer:
Jiří Kaiser (guarantor)
Tutor:
Jiří Kaiser (guarantor)
Supervisor:
Department of Applied Informatics
Synopsis:

Fundamental terms, information systems architecture, information system lifecycle, approaches to information system development, business process modeling using Business Process Model and Notation (BPMN) and Unified Modeling Language (UML), information system modeling  using UML, data modeling using ER diagrams, design of primary system database, database implementation using Structured Query Language (SQL), data retrieval from transaction systems and data processing, management information systems, OLAP measures and dimensions design and implementation, results reporting using pivot charts and tables.

Requirements:
Syllabus of lectures:

1 - 2. Explanation of keywords (data, information, knowledge, information system), architectures of information systems, information systems lifecycle, approaches to information system development

3 - 4. Process modeling using Business Process Model and Notation (BPMN)

5 - 6. Software requirements design using Unified Modeling Language (UML) - use case modeling, activity diagrams, state machine diagrams

7. Entity Relationship diagram, data model normalization

8. Data modeling using ER diagram, SQL - data types

9. SQL - database implementation

10 - 11. SQL - data retrieval

12. Management information systems, OLAP measures and dimensions, pivot tables and charts

Syllabus of tutorials:

1. Rich picture, Process hierarchy diagram

2 - 3. Business process modeling using BPMN

4 - 5. Business process modeling using UML (activity diagrams)

6 - 8. Use case diagram and use cases description

9 - 10. Activity diagram

11. State machine diagram

12. Entity relationship diagram

13. Data model normalization

14 - 17. Relational database design and implementation

18 - 21. Data retrieval from databases, data processing and reporting.

Study Objective:

Goal of the subject is to gain knowledge in branch of information systems. This includes ability to model and manage business processes, define requirements on information systems of enterprises, managing databases, data retrieval from databases and results reporting using pivot charts and tables.

Study materials:

ARLOW, J.: UML 2 and the unified process: practical object-oriented analysis and design, 2005

AMBLER, S.: The elements of UML 2.0 style, 2005

Business Process Model and Notation (BPMN). Documents Associated with Business Process Model and Notation (BPMN) Version 2.0, 2011

MySQL Reference Manuals

THOMSEN, E.: OLAP solutions: multidimensional information systems, 2002

Note:
Further information:
http://kix.fsv.cvut.cz/wiki/doku.php/en/bcmgr/128idbs
Time-table for winter semester 2019/2020:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Fri
Thu
Fri
roomTH:B-467

12:00–13:50
(lecture parallel1)
Thákurova 7 (FSv-budova A)
B467
roomTH:B-467

14:00–16:50
(lecture parallel1
parallel nr.101)

Thákurova 7 (FSv-budova A)
B467
Time-table for summer semester 2019/2020:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
Fri
Thu
Fri
roomTH:B-467

12:00–13:50
(lecture parallel1)
Thákurova 7 (FSv-budova A)
B467
roomTH:B-467

14:00–16:50
(lecture parallel1
parallel nr.101)

Thákurova 7 (FSv-budova A)
B467
The course is a part of the following study plans:
Data valid to 2020-07-06
For updated information see http://bilakniha.cvut.cz/en/predmet4795406.html