Inhalt

[ 521ANWEDI1V21 ] VL Databases and Information Systems 1

Versionsauswahl
(*) Unfortunately this information is not available in english.
Workload Education level Study areas Responsible person Hours per week Coordinating university
3 ECTS B1 - Bachelor's programme 1. year Computer Science Josef Küng 2 hpw Johannes Kepler University Linz
Detailed information
Original study plan Bachelor's programme Computer Science 2021W
Objectives Students understand architecture and operating principles of database systems. They are able to model data at conceptual and logical level and are proficient in applying according methodologies for that. They know formal query languages as well as in particular the structured query language SQL and can formulate complex queries. Additionally they know the theoretical foundations of the relational data model and the relational database design. They can apply it to real world situations. Furthermore, they understand transactions and first basics of multi user synchronization.
Subject General aspects of database systems and data models, general steps of a database design, ER-Model, Relational Model including transformation of a ER-diagram into relational schemata, Relational Algebra and SQL, Relational Database Design, Transactions and Multi-user-synchronization
Criteria for evaluation Written exam at the end of the semester.
Methods Standard lectures with study materials (slides) provided via KUSSS.
Language German
Study material Recommended reading (will not be needed if the lectures are attended on a regular basis): A. Kemper, A. Eickler: Datenbanksysteme Eine Einführung. 10. aktualisierte und erweiterte Auflage. Oldenbourg Verlag, 2015. R. Elmasri, S.B. Navathe: Fundamentals of Database Systems, 7. Edition, Pearson, 2016.
Changing subject? No
Corresponding lecture (*)INBIPVOIFS1: VL Informationssysteme 1 (3 ECTS)
On-site course
Maximum number of participants -
Assignment procedure Direct assignment