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

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

Preconditions

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

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

Title
TimeLocationInfoRegistration
Fundamentals of Databases
Fri, 2020-02-14, 16:00 till 17:30 PH: 2502
MW: 0350
CH: 21010
00.02.001
MI: 00.02.001
Interims II: 003
Interims II: 004
Interims I: 101
MW: 2050
MW: 0001
MW: 1050
MW: 1350
MW: 1450
MW: 1550
MW: 1801
MW: 2001
Interims I: 102
PH: 2501
Import till 2020-01-15 (cancelation of registration till 2020-02-07)
Top of page