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

Content

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.

Preconditions

IN0015 Discrete Structures, IN0001 Introduction to Informatics 1

Courses, Learning and Teaching Methods and Literature

Courses and Schedule

ArtSWSTitelDozent(en)Termine
VO 3 Grundlagen: Datenbanken (IN0008) Mittwoch, 10:30–13:00
Mittwoch, 10:30–13:00
UE 2 Tutorübungen zu Grundlagen: Datenbanken (IN0008) Termine in Gruppen

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

Media

Lecture with animated slides

Literature

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

There is a possibility to take the exam at the end of the semester.

Condensed Matter

When atoms interact things can get interesting. Fundamental research on the underlying properties of materials and nanostructures and exploration of the potential they provide for applications.

Nuclei, Particles, Astrophysics

A journey of discovery to understanding our world at the subatomic scale, from the nuclei inside atoms down to the most elementary building blocks of matter. Are you ready for the adventure?

Biophysics

Biological systems, from proteins to living cells and organisms, obey physical principles. Our research groups in biophysics shape one of Germany's largest scientific clusters in this area.