Data Modelling and Databases - Spring 2017

News

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

Description

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.

 

Lectures

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

 

Assistants

Send questions (if possible in English) about the exercices to sg-dmdb17@lists.inf.ethz.ch, which reaches all of us.

Name
E-mail
Claude Barthels claudeb@inf.ethz.ch
Eleftherios Sidirourgos eleftherios.sidirourgos@inf.ethz.ch
Eliza Wszola eliza.wszola@inf.ethz.ch
Ingo Müller (Head TA) ingo.mueller@inf.ethz.ch
Kaan Kara kaan.kara@inf.ethz.ch
Renato Marroquín renato.marroquin@inf.ethz.ch
Zsolt István zsolt.istvan@inf.ethz.ch

Literature

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

Lecturers:

Gustavo Alonso, Ce Zhang