- (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.

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.

- 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) |

# |
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 |

- 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)

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