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 exercise 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, exercises, 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, web interface for SQL, Database Normalizer (check relation definitions for compliance with normal forms), tool Interactive Relational Algebra


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

Top of page