de | en

Fundamentals of Databases

Module IN0008

This Module is offered by TUM Department of Informatics.

This module handbook serves to describe contents, learning outcome, methods and examination type as well as linking to current dates for courses and module examination in the respective sections.

Basic Information

IN0008 is a semester module in German language at Bachelor’s level which is offered in winter semester.

Total workloadContact hoursCredits (ECTS)
180 h 75 h 6 CP

Content, Learning Outcome and Preconditions


SQL, data integrity, theory of relational database design, physical data organisation (storage structures, index structures), query processing, transaction management, main features of error handling (recovery, backup) and multi-user synchronisation, security aspects (authorization), XML data modeling (optional); in the tutorial the content is practiced along concrete examples

Learning Outcome

Students are able to apply the essential concepts of relational database systems and can use and evaluate them systematically and in a qualified manner.
The students have the expertise to systematically use a database system starting from the conceptual design to the implementation design to the physical design. They are able to formulate even complex queries in SQL and have a basic understanding of logical and physical optimization based on relational algebra. Furthermore they know how to safe-guard a database application with respect to recovery, concurrency control and authorization.


IN0015 Discrete Structures, IN0001 Introduction to Informatics 1

Courses, Learning and Teaching Methods and Literature

Courses and Schedule

Learning and Teaching Methods

Lecture, tutorial, problems for individual study, web interface to the data base system HyPer for actively testing SQL queries and self-study of query plans


Lecture with animated slides


- Alfons Kemper, André Eickler: Datenbanksysteme. Eine Einführung. 8., aktualisierte und erweiterte Auflage, Oldenbourg Verlag, 2011
- A. Kemper, M. Wimmer: Übungsbuch: Datenbanksysteme. 3. Auflage Oldenbourg Verlag, 2012
- A. Silberschatz, H. F. Korth, S. Sudarshan: Database System Concepts. Sixth Edition, McGraw-Hill, 2010

Module Exam

Description of exams and course work

The academic assessment will be done by a 90 minutes written exam. Assignments checking knowledge verify the familiarity with the main concepts of relational database systems. Transfer assignments and small scenarios check the ability to apply and evaluate these concepts systematically and in a qualified manner.

Exam Repetition

The exam may be repeated at the end of the semester.

Current exam dates

Currently TUMonline lists the following exam dates. In addition to the general information above please refer to the current information given during the course.

Fundamentals of Databases
Fri, 2022-02-18, 18:15 till 19:45 MW: 1550
MW: 1350
Interims II: 003
Interims I: 101
MI: 00.02.001
Interims II: 004
MW: 0001
MW: 2001
MW: 1801
Präsenzprüfung till 2022-01-15 (cancelation of registration till 2022-02-11)
Top of page