Course: Database Systems II

« Back
Course title Database Systems II
Course code USII/PDBS2
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study 2
Semester Summer
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
  • Š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.

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 (course PDBS2) 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. Pardubice, 2013.
  • Šimonová, S., Panuš, J., Naiman,K. Databázové systémy II - SQL, přístup k datovým zdrojům.. Pardubice, 2006.
  • Teorey, T., Lightstone, S., Nadeau, T., Jagadish, H. Database modeling and design. 2011.

Study plans that include the course