UIN2013 Database Systems I

Faculty of Philosophy and Science in Opava
Winter 2012
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. 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.
The course is also listed under the following terms Winter 2005, Winter 2007, Winter 2008, Winter 2009, Winter 2010, Winter 2011, Winter 2013, Winter 2014, Winter 2015, Winter 2016, Winter 2017, Winter 2018, Winter 2019, Winter 2020, Winter 2021, Winter 2022.
  • Enrolment Statistics (Winter 2012, recent)
  • Permalink: https://is.slu.cz/course/fpf/winter2012/UIN2013