Zde můžete vidět rozdíly mezi vybranou verzí a aktuální verzí dané stránky.
| — | bcmgr:128idbs [2018/05/02 15:28] (aktuální) – vytvořeno kaiser | ||
|---|---|---|---|
| Řádek 1: | Řádek 1: | ||
| + | ======128IDBS -- Information Systems and Database Systems====== | ||
| + | |Weekly load | ||
| + | |Semester | ||
| + | Description: | ||
| + | Fundamental terms, information systems architecture, | ||
| + | Goals of Study: | ||
| + | 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, | ||
| + | |||
| + | Outline of Lectures: | ||
| + | 1 - 2. Explanation of keywords (data, information, | ||
| + | 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 \\ | ||
| + | |||
| + | Outline of Excercises: | ||
| + | 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. \\ | ||
| + | |||
| + | Recommended literature: | ||
| + | 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 \\ | ||
| + | \\ | ||
| + | Keywords: | ||
| + | Information system, business process, BPMN, UML, SQL, use case modeling, ER model, information system architecture, | ||
| + | |||
| + | Teacher: Ing. Kaiser Jiří Ph.D. | ||