Data Modelling and Databases

News

  • (06.06) Solution 9 is online
  • Midterm-Exams review:  
    • Donnerstag 12.06. 14:00-16:00 (CAB F 78)
    • Donnerstag 19.06. 14:00-16:00 (CAB F 78)
  • (26.05) Third exam results are published here
  • (16.05) Exercise 6 + Solution 6 are updated (last task)
  • (16.05) Exercise 9 is online
  • (16.05) Solution 8 is online
  • (15.05) Solution 7 is online
  • Third Exam: May 21, 8:15 - 8:45 in CAB G 61.
  • (09.05) Exercise 8 is online
  • (02.05) Solution 6 is online
  • (28.04) Exercise 7 is online
  • (23.04) Exercise 6 is online
  • (17.04) Second exam results are published here
  • (13.04) Solution 5 is online
  • (05.04) Exercise 5 is online
  • (05.04) Solution 4 is online
  • (31.03) Solution 3 is online.
  • Second Exam: April 9, 8:15 - 8:45 in CAB G 61.
  • (26.03) Exercise 4 is online. 
  • (21.03) First exam results are published here.
  • (12.03) Solution 2 is online.
  • (10.03) Exercise 3 is online. 
  • (10.03) Project description and template are online.
  • First Exam: March 17, 10:15 - 10:45 in CAB G 61.
  • (07.03) Solution 1 is online.
  • (03.03) Exercise 2 is online.
  • (24.02) Exercise 1 is online.
  • (21.02) Exercise groups 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 »  Cagri Balkesen/Renato Maroquin (English)
  08-10 ML F 34 »  Claude Barthels/David Sidler (German) 
  08-10 HG D 5.1 »  Attila Printz (German)
Fri 08-10 CAB G 52 »  Markus Pilman (German)
  08-10 CAB G 56 »  Reto Achermann (German)
  08-10 CAB G 57 »  Besmira Nushi (English)

Lectures

 

 # Slides
1 a. Administrative Details PPT PDF (updated 17.2.2014)
b. Introduction PPT PDF
2 ER, UML PPT PDF
3 Relational Model PPT PDF
4 SQL I PPT PDF
5 SQL II PPT PDF
6 Integrity Constraints PPT PDF
7 Normal Forms  PPT PDF
8 Query Processing PPT  PDF
9 Transactions PPT  PDF
10 Security PPT  PDF
11 Object-relational Databases PPT   PDF

 

Exercises (Start March 4th)

 

Project

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.

Lectures

Donald Kossmann

 

 

 

Upload File: