| 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)
|
