|
Lecturer(s)
|
-
Šimonová Stanislava, doc. Ing. Ph.D.
|
|
Course content
|
Approaches towards data modeling. SQL, commands for data manipulation. SQL, commands for data definition. UML, objects, classes, heritability, attributes and methods. Class mapping into the relational data model. UML, messages and operations, sequence diagram. Data integrity in analysis, design and implementation. Multi-dimension modelling of a data warehouse, fact tables and dimension tables. Transaction processing, transaction, recovery from failure. Centralized and distributed database systems.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Laboratory work
|
|
Learning outcomes
|
The aim of the course is to deepen theoretical and practical knowledge about database systems and is the follow-up course to the Database systems I.
Students will be able to perform questions using commands of the SQL language, and to map the object-oriented data model into the relational data model. They will understand how to define integrity limitations in all phases of development of the information database system. Furthermore, they will be able to model and design data warehouses as well as understand impacts of transaction processing, and principles of centralized and distributed databases.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Oral examination, Written examination, Didactic test, Discussion
The assignment is granted elaboration of given tasks; there are made public in the system Moodle at the beginning of semester (information about password is available in the system STAG - Study material (studijní materiály)). The examination consists of two parts, written and oral. It examines theoretical knowledge of presented themes and the student ability of practical task elaboration. The examination involves topics of subjects DBS1 as well as DBS2.
|
|
Recommended literature
|
-
Kanisová, H., Muller, M. UML srozumitelně. Brno, 2006.
-
Novotný, O., Pour, J., Slánský, D. Business Intelligence - jak využít bohatství ve vašich datech. Praha, 2005.
-
Systémy nápovědy. pro používané programové produkty.
-
Šimonová, S. Databázové systémy I (elektronický kurz pro KDBS1 v systému Moodle). Pardubice, 2013.
-
Šimonová, S., Panuš, J., Naiman,K. Databázové systémy II - SQL, přístup k datovým zdrojům (k dispozici v elektronické formě v sekci Studijní materiály v systému STAG). Pardubice, 2006.
-
Teorey, T., Lightstone, S., Nadeau, T., Jagadish, H. Database modeling and design. 2011.
|