Course: Database systems I

« Back
Course title Database systems I
Course code UI/NK213
Organizational form of instruction Lecture + Seminary
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 6
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Course availability The course is available to visiting students
Lecturer(s)
  • MARČEK Dušan, prof. Ing. CSc.
  • LANGER Miroslav, RNDr. Ph.D.
Course content
1. Introduction to data base systems 2. Database management systems 3. The architectures of databases 4. Components of database systems 5. Date description language 6. Date manipulation language 7. Models of database 8. Relational database model 9. Internal data organization 10. Theory of dependencies 11. Normal forms of database 12. Design of relational databases Activities None Garantors and lectures * Guarantor: Prof. Ing. Dušan MARČEK, CSc. * Lecturer: Prof. Ing. Dušan MARČEK, CSc. * Tutorial lecturer: RNDr. Miroslav LANGER, Ph.D. Literature * Basic: MARČEK, M.: Technologie zpracování dat, databázové zpracování. SU, FPF, Ústav informatiky, Opava, 2008 , ISBN: 978-80-7248-480-5. * Further literature: HOFFER, Jeffrey A., Ramesh VENKATARAMAN a Heikki TOPI. Modern Database Management. 10. vyd. Upper Saddle River: Prentice Hall, 2011. ISBN 978-0-13-608839-4. * Recommended: POKORNÝ, J. a kol.: Databázové systémy a jejich použití v informačních systémech. Praha, ČVUT, 1998. Prerequisities None Other requirements 1 ongoing test, combined exam

Learning activities and teaching methods
Interactive lecture, Lecture with a video analysis
Recommended literature
  • GROFF, R. James a Paul N. WEINBERG. SQL kompletní průvodce. Brno, CP, 2005. ISBN 80-251-0369-2.
  • MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava,SU FPF, UI, 2008. ISBN 978-80-7248-480-5.
  • POKORNÝ, J. a kol. Databázové systémy a jejich použití v informačních systémech. Praha, ČVUT, 1998.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Philosophy and Science in Opava Computer Science and Technology (1) Electrical engineering, telecommunication and IT 3 Winter