VVZ API is not affiliated with ETH Zurich. Data might be outdated or incorrect. Please view the official ETHZ Vorlesungsverzeichnis for binding information.

252-0063-00L 7 Credits BSC , MSC D-BSSE , D-INFK
You're viewing possible stale or outdated data. Please check the latest semester for more up-to-date information.

Data Modelling and Databases

Lecturers & Examiners: Dr. Ce Zhang
VVZ CR 3.34

Last Updated: 2026-02-05 16:07:42

Abstract

Data modelling (Entity Relationship), relational data model, relational design theory (normal forms), SQL, database integrity, transactions and advanced database engines

Objective

Introduction to relational databases and data management. Basics of SQL programming and transaction management.

Content

The course covers the basic aspects of the design and implementation of databases and information systems. The courses focuses on relational databases as a starting point but will also cover data management issues beyond databases such as: transactional consistency, replication, data warehousing, other data models, as well as SQL.

Resources

Literature

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

Learning Materials (Links)

General Information

Language
English
Levels
BSC , MSC
Frequency
Yearly recurring

Examination

Type
session examination
Mode
written 120 minutes
Aids
In sämtlichen Prüfungen sind keine Hilfsmittel erlaubt.In the exam, no supporting material is allowed
Digital
The exam takes place on devices provided by ETH Zurich.

Course Components

Type Title Time & Place Hours
lecture Data Modelling and Databases
  • Wed 14:15-16:00 (ML D 28)
  • Fri 08:15-10:00 (ML D 28)
4 h weekly
exercise Data Modelling and Databases
Groups are selected in myStudies.
  • Thu 16:15-18:00 (HG F 5)
  • Fri 14:15-16:00 (CHN C 14)
2 h weekly

Offered In