FPF:UIBUC28 Database Systems II - Course Information
UIBUC28 Database Systems II
Faculty of Philosophy and Science in OpavaSummer 2012
- Extent and Intensity
- 2/2/0. 5 credit(s). Type of Completion: zk (examination).
- Teacher(s)
- prof. Ing. Dušan Marček, CSc. (lecturer)
Mgr. Marek Menšík, Ph.D. (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
- Computer science in combination with another discipline (programme FPF, B1803 InDO)
- Computer science in combination with another discipline (programme FPF, B6107 HuSt)
- 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.
- Enrolment Statistics (Summer 2012, recent)
- Permalink: https://is.slu.cz/course/fpf/summer2012/UIBUC28