UIKS220 Database systems I

Faculty of Philosophy and Science in Opava
Winter 2017
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
Prerequisites (in Czech)
Znalost programování, znalost operačních systémů, základy informatiky.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
The course focuses on DB technology for their utilization and application in enterprices and institutions. The aim is to understand the use of DB technology, their theoretical background practical design and deployments, offers an understanding of DB architectures and understanding of their implementation.
Syllabus
  • 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
Literature
    required literature
  • MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava, SU FPF, UI, 2008. ISBN 978-80-7248-480-5. info
    recommended literature
  • POKORNÝ, J. a kol. Databázové systémy a jejich použití v informačních systémech. Praha, ČVUT, 1998. info
    not specified
  • GROFF, R. James a Paul N. WEINBERG. SQL kompletní průvodce. Brno, CP, 2005. ISBN 80-251-0369-2. info
Teaching methods
Interactive lecture
Lecture with a video analysis
Assessment methods
Exam
Language of instruction
Czech
Further comments (probably available only in Czech)
The course can also be completed outside the examination period.
Teacher's information
Theoretical understanding of topic specified in Scope of Contents
Demonstration practical skills in database design
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 2011, Winter 2012, Winter 2013, Winter 2014, Winter 2015, Winter 2016, Winter 2018.
  • Enrolment Statistics (Winter 2017, recent)
  • Permalink: https://is.slu.cz/course/fpf/winter2017/UIKS220