Information Systems and Database Systems

Kód předmětu: 128IDBS
Garant předmětu: Ing. Jiří Kaiser, Ph.D.
Zakončení předmětu: Z,ZK
Počet kreditů: 6 kred.
Rozsah výuky: 2+3
Web předmětu: http://kix.fsv.cvut.cz/wiki/doku.php/en/bcmgr/128idbs

Anotace(semestr B232)
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.
Obsah 
Basic terms in the field of information systems, basic types of available applications for enterprise information systems, information system architectures, BMPN, UML languages and relevant software tools, management information systems - design of OLAP indicators, pivot charts, and tables. Modeling relational databases using E-R diagrams, Data model normalization, Platform-specific data model, and SQL.
Literatura 
[1]  ARLOW, J.: UML 2 and the unified process: practical object-oriented analysis and design, 2005
[2]  AMBLER, S.: The elements of UML 2.0 style, 2005
[3]  Business Process Model and Notation (BPMN). Documents Associated with Business Process Model and Notation (BPMN) Version 2.0, 2011
[4]  MySQL Reference Manuals
[5]  THOMSEN, E.: OLAP solutions: multidimensional information systems, 2002
Návaznosti 
--
Studijní plány 
--