Data Modelling and Databases - Spring 2017


  • The first lecture will take place on the 22nd of February.
  • The first exercise will take place on the 27th of February (no exercises in the first week).
  • The two exams from last year are now available on the exercise page for practice.


The course teaches the basics of modeling, querying, and managing data.

The course focuses on relational databases, but also covers other forms of data processing engines, such as those used today in Internet applications.

The course covers the following topics: entity-relationship model, relational modeling, the relational data model, relational data modeling theory (normal forms), SQL, referential integrity, transactions, replication, and internet scale data management.



Wed 13-15 HG F 3
Fri 08-10 HG F 3

Exercises (choose one)

Mon 15-17 CHN C 14
Fri 13-15 CAB G 51

Detailed Timetable



Send questions (if possible in English) about the exercices to, which reaches all of us.

Claude Barthels
Eleftherios Sidirourgos
Eliza Wszola
Ingo Müller (Head TA)
Kaan Kara
Renato Marroquín
Zsolt István


  • Kemper, Eickler: Datenbanksysteme: Eine Einführung. Oldenbourg Verlag, 7. Auflage, 2009. or
  • Garcia-Molina, Ullman, Widom: Database Systems: The Complete Book. Pearson, 2. Auflage, 2008.


Gustavo Alonso, Ce Zhang