Data Modelling and Databases

News

  • (13.5) Exercise 9 is uploaded
  • (07.5) Exercise 8 is uploaded
  • (6.05) CrowdBet and CrowdIt Slides
  • (02.5) Exercise 7 is uploaded
  • (21.4) Details about project part 2 are online
  • (16.4) Exercise 5 is uploaded
  • (08.4) Exercise 4 is uploaded
  • (18.3) Exercise 3 is uploaded
  • (11.3) Exercise 2 is uploaded
  • (04.3) Details about project part 1 are online
  • (25.2) Exercise groups and exercise 1 are uploaded. 

Description

This lecture teaches the basics of modeling and implementation of databases and information systems. 

The lecture focuses on relational databases, but also covers extended models, e.g. for scientific applications or models used in the Internet. 

More precisely, the lecture is about the following topics: E/R and UML modeling, the relational data model, object relational models, semi-structured data models and XML, relational data modeling theory (normal forms), SQL, referential integrity, security, transactions and data warehousing.

Timetable

Lecture
Mo, 10−12h, CAB G 61
Wed,  08-10h, CAB G 61
Exercises
  Time Room Teaching Assistant
Tue 08-10 CHN E 46 »  Simon Loesing (German)
  08-10 ML F 34 »  Sebastian Wicki (German)
  08-10 HG D 5.1 »  Giorgos Giannikis (English)
Fri 08-10 CAB G 52 »  Janick Griner (German)
  08-10 CAB G 56 »  Louis Woods (German)
  08-10 CAB G 57 »  Besmira Nushi (English)

Lectures

 # Slides
1 Introduction
2 ER, UML
3 Relational Models
4 SQL
5 Embedded SQL
6 Constraints
7 Normal Forms
8 Query Processing
9 Transactions
10 Security
11 Object-relatational Databases

 

Exercises

  • Exercise Groups  (for questions contact Simon Loesing)
  • Exercise 1 (Solution)
  • Exercise 2 (Solution)
  • Exercise 3 (Solution)
  • Exercise 4 (Solution)
  • Exercise 5 (Solution)
  • Exercise 6 (Solution)
  • Exercise 7 (Solution)
  • Exercise 8 (Solution)
  • Exercise 9 (Solution)

Project

Project Part 1
 
Project Part 2

 

Literature

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

Lectures

Donald Kossmann