19301501 Lecture

SoSe 21: Database Systems

Agnès Voisard

Additional information / Pre-requisites

Requirements

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

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.

close

Suggested reading

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

27 Class schedule

Additional appointments

Tue, 2021-07-13 14:00 - 16:00
Klausur

Location:
Virtueller Raum 05

Regular appointments

Tue, 2021-04-13 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-04-20 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-04-27 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-05-04 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-05-11 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-05-18 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-05-25 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-06-01 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-06-08 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-06-15 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-06-22 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-06-29 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-07-06 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Tue, 2021-07-13 14:00 - 16:00
Datenbanksysteme (Serientermin 1)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-04-15 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-04-22 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-04-29 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-05-06 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-05-20 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-05-27 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-06-03 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-06-10 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-06-17 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-06-24 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-07-01 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-07-08 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Thu, 2021-07-15 14:00 - 16:00
Datenbanksysteme (Serientermin 2)

Lecturers:
Univ.-Prof. Dr. Agnès Voisard

Location:
Virtueller Raum 03

Subjects A - Z