FPF:UINK214 Database Systems II - Course Information
UINK214 Database Systems II
Faculty of Philosophy and Science in OpavaSummer 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
- Computer Science and Technology (programme FPF, B1801 Inf)
- 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 2011, recent)
- Permalink: https://is.slu.cz/course/fpf/summer2011/UINK214