19301501 Lecture

SoSe 16: Datenbanksysteme

Agnès Voisard

Additional information / Pre-requisites

Requirements

"Data Structures and Daten Abstraction" or "Informatik B"

Comments

Content

Database design with ER. 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.

Technical: Transaction subject, transactional guaranties,
synchronization of multi user operations, fault tolerance features.
Application and new developments: data warehouse systems, data mining,
information retrieval/search engines. 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

Thu, 2016-06-30 14:00 - 16:00
Klausur

Lecturers:
Daniel Kreßner

Location:
Hs 1a Hörsaal (Habelschwerdter Allee 45)
Hs 1b Hörsaal (Habelschwerdter Allee 45)

Thu, 2016-07-21 14:00 - 16:00
Nachklausur

Lecturers:
Daniel Kreßner

Location:
Hs 1a Hörsaal (Habelschwerdter Allee 45)
Hs 1b Hörsaal (Habelschwerdter Allee 45)

Regular appointments

Tue, 2016-04-19 14:00 - 16:00

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

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

Tue, 2016-04-26 14:00 - 16:00

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

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

Tue, 2016-05-03 14:00 - 16:00

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

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

Tue, 2016-05-10 14:00 - 16:00

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

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

Tue, 2016-05-17 14:00 - 16:00

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

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

Tue, 2016-05-24 14:00 - 16:00

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

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

Tue, 2016-05-31 14:00 - 16:00

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

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

Tue, 2016-06-07 14:00 - 16:00

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

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

Tue, 2016-06-14 14:00 - 16:00

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

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

Tue, 2016-06-21 14:00 - 16:00

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

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

Tue, 2016-06-28 14:00 - 16:00

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

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

Tue, 2016-07-05 14:00 - 16:00

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

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

Tue, 2016-07-12 14:00 - 16:00

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

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

Tue, 2016-07-19 14:00 - 16:00

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

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

Thu, 2016-04-21 14:00 - 16:00

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

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

Thu, 2016-04-28 14:00 - 16:00

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

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

Thu, 2016-05-12 14:00 - 16:00

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

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

Thu, 2016-05-19 14:00 - 16:00

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

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

Thu, 2016-05-26 14:00 - 16:00

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

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

Thu, 2016-06-02 14:00 - 16:00

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

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

Thu, 2016-06-09 14:00 - 16:00

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

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

Thu, 2016-06-16 14:00 - 16:00

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

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

Thu, 2016-06-23 14:00 - 16:00

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

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

Thu, 2016-06-30 14:00 - 16:00

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

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

Thu, 2016-07-07 14:00 - 16:00

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

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

Thu, 2016-07-14 14:00 - 16:00

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

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

Thu, 2016-07-21 14:00 - 16:00

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

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

Subjects A - Z