UINK214 Database Systems II

Faculty of Philosophy and Science in Opava
Summer 2011
Extent and Intensity
2/2/0. 6 credit(s). Type of Completion: zk (examination).
Teacher(s)
prof. Ing. Dušan Marček, CSc. (lecturer)
prof. Ing. Dušan Marček, CSc. (seminar tutor)
Guaranteed by
prof. Ing. Dušan Marček, CSc.
Institute of Computer Science – Faculty of Philosophy and Science in Opava
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
1. A model of real world, conceptual model, basic components. 2. The ERA conceptual model, the set of entities, attributes, integrity constrains. 3. Conversion of ERA model into relation schemes, database design. 4. The HIT model, ISA hierarchy. 5. Information capacity of data structures. 6. Conversion of HIT model into relation schemes. 7. Distributed database systems, fragments of relations, optimizing transmission costs. 8. Data warehouse, environment structure, building of data warehouses, used technologies. 9. Data warehouse fragmentation: primary, horizontal and derived fragmentation, fragmentation of multidimensional model. Labs.: Follow the contents and structure of lectures.
Language of instruction
Czech
Further Comments
The course can also be completed outside the examination period.
The course is also listed under the following terms Summer 2010, Summer 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2017, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023.
  • Enrolment Statistics (Summer 2011, recent)
  • Permalink: https://is.slu.cz/course/fpf/summer2011/UINK214