UIINP22 Database systems I

Faculty of Philosophy and Science in Opava
Winter 2020
Extent and Intensity
2/2/0. 6 credit(s). Type of Completion: zk (examination).
Teacher(s)
RNDr. Miroslav Langer, Ph.D. (lecturer)
prof. Ing. Dušan Marček, CSc. (lecturer)
Guaranteed by
RNDr. Miroslav Langer, Ph.D.
Institute of Computer Science – Faculty of Philosophy and Science in Opava
Timetable
each odd Wednesday 15:35–18:50 B3b
  • Timetable of Seminar Groups:
UIINP22/A: Thu 8:05–9:40 B3b, M. Langer
Prerequisites (in Czech)
TYP_STUDIA(B)
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
The subject of the course is the database technologies and their use in companies and institutions. The aim is to understand the use of database technologies from the theoretical and practical points of view. In the course it is discussed and evaluated the performance of data and information processing using database technology, it is offered an understanding of architectures and designing database systems. Tutorials are in the form of project education in the MS SQL Server database system.
Learning outcomes
Students will gain theoretical knowledge of the architecture of the database systems and models, normal forms and design of the database. They will also gain practical knowledge of SQL.
Syllabus
  • 1. Introduction to the database systems
  • 2. Database management system
  • 3. The architecture of the database system
  • 4. Components of the database system
  • 5. Data Definition Language (DDL)
  • 6. Data Manipulation Language (DML)
  • 7. Data models
  • 8. Relation Database Model
  • 9. Internal level of the organization of the data
  • 10. Dependency theory
  • 11. Normal forms of a database
  • 12. Relational database design
Literature
    required literature
  • MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava, 2008. ISBN 978-80-7248-480-5. info
    recommended literature
  • POKORNÝ, J and M VALENTA. Databázové systémy. Česká technika - nakladatelství ČVUT, 2013. ISBN 978-80-01-05212-9. info
  • GROFF, R. James a Paul N. WEINBERG. SQL kompletní průvodce. Brno: CP Books, 2005. ISBN 80-251-0369-2. info
Teaching methods
Interactive lecture, tutorial
Assessment methods
Credit: Compulsory attendance at tutorials min. 75%. Written test, demonstration of the practical knowledge gained from the tutorials.
Exam: Written test.
Language of instruction
Czech
Further Comments
Study Materials
The course can also be completed outside the examination period.
The course is also listed under the following terms Winter 2019, Winter 2021, Winter 2022, Winter 2023, Winter 2024.
  • Enrolment Statistics (Winter 2020, recent)
  • Permalink: https://is.slu.cz/course/fpf/winter2020/UIINP22