UIKS220 Database Systems I

Faculty of Philosophy and Science in Opava
Winter 2011
Extent and Intensity
2/0/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
prof. Ing. Dušan Marček, CSc. (lecturer)
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.
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 1993, Winter 1994, Winter 1995, Winter 1996, Winter 1997, Winter 1998, Winter 1999, Winter 2000, Winter 2001, Winter 2002, Winter 2003, Winter 2004, Winter 2006, Winter 2007, Winter 2008, Winter 2009, Winter 2010, Winter 2012, Winter 2013, Winter 2014, Winter 2015, Winter 2016, Winter 2017, Winter 2018.
  • Enrolment Statistics (Winter 2011, recent)
  • Permalink: https://is.slu.cz/course/fpf/winter2011/UIKS220