Introduction to Database Systems

News

(05 July 2007) Final results of the exam are available here.

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

Mi 10-12 HG E 3

Exercise Group Schedule

New --- Click here to see which exercise group you belong to

Exam Information

There will be no midterm exam. Here are the details of the final exam:

Date: 5. July 2007, 10:15 am (please, arrive at 10am)

Duration: 60 minutes

Location:

• CAB G11: Family names starting with A-M
• CAB G51: Familiy names starting with N-Z

The exam is closed book. (Keine Hilfsmittel!)

Lecture notes / Exercises / Project

See here

Goal

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

Lecturer

Prof. Dr. Donald Kossmann

Teaching Assistant

• Tim Kraska <tim.kraska-at-inf.ethz.ch>
• Oliver Keller <kellero-at-ethz.ch>
• Tobias Abt <abtt-at-student.ethz.ch>
• Eric Lo <eric.lo-at-inf.ethz.ch>

Language

German

Literature

Kemper, Eickler: Datenbanksysteme: Eine Einführung. Oldenbourg Verlag, 6. Auflage, 2006

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

Podcast

Podcasts of the lectures are available here.

Visio diagram shapes

Visio does not provide the standard ER model shapes. For the context of this course, we have created a Visio Shape file containing the necessary shapes. It can be downloaded here (Note: Visio is free via the Microsoft Academic Alliance (MSDNAA))