19301501 Lecture

Database Systems

Katharina Baum

Location: T9/SR 005 Übungsraum (Takustr. 9)

Schedule: Di 10:00-12:00, Di 12:00-13:00, Di 14:00-16:00, Do 10:00-12:00, zusätzliche Termine siehe LV-Details

Class starts on: 2025-10-14

Course language: English

Contact hours: 3

Limited attendance: No

Attendance required: No

Relevant semester: 2

Modules where this course belongs: 0086bA3.3 0086cA3.2 0086eA1.11 0087dA1.6 0087eA1.8 0132cA2.2 0260cA4.1 0590aB1.20 0590bB2.9 E24nA1.1 E61aA1.1

Additional information / Pre-requisites

Requirements

  • ALP 1 - Functional Programming
  • ALP 2 - Object-oriented Programming
  • ALP 3 - Data structures and data abstractions
  • OR Informatik B

Comments

Content

Database design with ERM/ERDD. Theoretical foundations of relational database systems: relational algebra, functional dependencies, normal forms. Relational database development: SQL data definitions, foreign keys and other integrity constraints, SQL as applicable language: essential language elements, embedding in programming language. Application programming; object-relational mapping. Security and protection concepts. Transaction subject, transactional guaranties, synchronization of multi user operations, fault tolerance features. Application and new developments: data warehousing, data mining, OLAP.

Project: the topics are deepened in an implementation project for student groups.

Suggested reading

  • Alfons Kemper, Andre Eickler: Datenbanksysteme - Eine Einführung, 5. Auflage, Oldenbourg 2004
  • R. Elmasri, S. Navathe: Grundlagen von Datenbanksystemen, Pearson Studium, 2005

71 Class schedule

Additional appointments

Tue, 2026-02-17 09:30 - 12:00
Klausur

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/Gr. Hörsaal (Takustr. 9)

Regular appointments

Tue, 2025-10-14 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-10-21 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-10-28 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-11-04 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-11-11 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-11-18 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-11-25 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-12-02 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-12-09 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-12-16 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-12-23 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-12-30 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2026-01-06 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2026-01-13 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2026-01-20 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2026-01-27 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2026-02-03 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2026-02-10 10:00 - 12:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-10-16 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-10-23 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-10-30 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-11-06 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-11-13 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-11-20 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-11-27 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-12-04 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-12-11 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-12-18 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2025-12-25 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2026-01-01 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2026-01-08 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2026-01-15 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2026-01-22 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2026-01-29 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2026-02-05 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Thu, 2026-02-12 10:00 - 12:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/SR 005 Übungsraum (Takustr. 9)

Tue, 2025-10-21 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-10-28 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-11-04 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-11-11 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-11-18 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-11-25 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-12-02 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-12-09 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-12-16 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-12-23 14:00 - 16:00
Übung 02

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-12-30 14:00 - 16:00
Übung 02

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2026-01-06 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2026-01-13 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2026-01-20 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2026-01-27 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2026-02-03 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2026-02-10 14:00 - 16:00
Übung 02

Location:
T9/051 Seminarraum (Takustr. 9)

Tue, 2025-10-21 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-10-28 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-11-04 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-11-11 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-11-18 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-11-25 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-12-02 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-12-09 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-12-16 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-12-23 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2025-12-30 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2026-01-06 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2026-01-13 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2026-01-20 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2026-01-27 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2026-02-03 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2026-02-10 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)

Tue, 2026-02-17 12:00 - 13:00
Database Systems

Lecturers:
Prof. Dr. Katharina Baum

Location:
T9/K40 Multimediaraum (Takustr. 9)