FPF:UIN2013 Database Systems I - Course Information
UIN2013 Database Systems I
Faculty of Philosophy and Science in OpavaWinter 2010
- 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)
- Computer Science and Technology (programme FPF, M1801 Inf)
- Secondary School Teacher Training in Computer Science (programme FPF, M7504)
- Secondary school teacher training in general subjects with specialization in Computer Science (programme FPF, M7504)
- Course objectives
- 1. Batch processing tasks, hardware and software environment, imperfections and problems. 2. Basic database concepts, file management system, basic database system terminology, 3-level architecture of database systems. 3. Physical data organisation: models for external storage organisation, sequential, hashed, indexed files, B/trees, files with variable length records. 4. Relational model, relation schemes, relational algebra, relational calculus. 5. Query languages, features of data manipulation languages, language SQL, data definition, data manipulation, query formulation. 6. Design and development of relational database systems: functional dependences, decomposition of relation schemes, normal forms for relation schemes, multi-valued dependencies. 7. The network model and the DBTG proposal, implementation of networks, the hierarchical model, implementation of hierarchical databases. 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 (Winter 2010, recent)
- Permalink: https://is.slu.cz/course/fpf/winter2010/UIN2013