Introduction to Database Systems

Exam Information

You may look at the written exams on August 10 (Prüfungseinsicht). Please come to CAB F 56.2 between 10.00 and 12.00.

Overall results (grades from midterm and final) are available. Please use your n.ethz username and password when accessing them.

Midterm results are available. Please use your n.ethz username and password when accessing them

Important Course Information (Please read!)

Information about the exercise groups

Information on the lecture, Übungsgruppen, project, and exams.

Student Message Board

Please access the VIS message board of the lecture, for project and lecture-related questions.

Feel free to post and answer questions. The coordinators of the exercise groups will also offer, of course, their support.

Contents

This lecture presents the basic tools required for the development of database applications. The focus is on relational database systems and applications that can be built using relational database technology.

The following topics will be covered: E/R and UML modelling, the relational data model, relational design theory (normal forms), SQL, database intregrity, security, a brief introduction to transactions and data warehousing (OLAP).

Lecture notes

See the lecture notes page.

Goal

Good understanding of relational database systems. Ability to use database systems to develop database applications.

Lecturer

Prof. Dr. Donald Kossmann

Course Registration/Einschreibung

The registration for the exercise groups is over. Please find your exercise group and group coordinator at the following link : Übungsgruppeneinteilung.

Review your registration data and user Id here.

Schedule

2V1U

Language

German

Literature

Kemper, Eickler: Datenbanksysteme: Eine Einführung. Oldenbourg Verlag, 5. Auflage, 2004

Elmasri, Navathe: Grundlagen von Datenbanksystemen (Ausgabe Grundstudium). Pearson Studium, 3. Auflage, 2005.