|
Lecturer(s)
|
-
Šimonová Stanislava, doc. Ing. Ph.D.
|
|
Course content
|
Database systems as the technology platform company information systems. Data processing, database technology. Approaches to development of information system with targeted implementation in relational database platform. Complex use of structured approach. Development standard Unified Modeling Language, objects, classes, methods, generalization and specialization, class diagram. Development standard Unified Modeling Language, messages and operations, sequence diagram, communication diagram. Mapping of data structures to relational model data relations, mapping variation, technological implications. Database standard Structured Query Language, data manipulation commands. Database standard Structured Query Language, data definition commands. Data integrity in the process of analysis, design and implementation of information system development. Multidimensional data warehouse modeling, fact and dimension tables. Data as a part of IT service, IT service value, IT IT (Information Technology Infrastructure Library) framework. Determining data requirements for information systems, methods for obtaining data requirements, and tools for determining the importance of data requirements.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Laboratory work
|
|
Learning outcomes
|
Learning outcomes of the course unit The aim of the course is - in relation to the subject Database Systems I - to deepen the theoretical and practical knowledge of the principles of database systems and the variation of their application in the development of enterprise information resources.
A student who has successfully completed the course can: to characterize the linkages of database systems in organizations to key business processes and have an idea of the necessary interoperability of processes with information resources; describe the principles of selected UML models; explain and apply data integrity principles in the information system development process; use selected SQL statements; to characterize data warehouse principles and create models within dimensional modeling; to orientate in ways of obtaining data requirements in accordance with the ITIL (Information Technology Infrastructure Library) principles.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Oral examination, Written examination, Didactic test, Discussion
The assignment: elaboration of partial tests, elaboration of assigned tasks, attendance at seminars in accordance with FEA directive. The examination: consists of a written and an oral part; the degree of knowledge and ability to apply acquired knowledge to solving practical problems is tested, the condition is to obtain credit.
|
|
Recommended literature
|
-
Coronel,C. Database Principles - Fundamentals of Design, Implementation, and Management. Andover Cengage Learning EMEA, 2013.
-
Lee, J. Big Data Modelling. 2018.
|