19301501 Lecture

SoSe 17: Database systems

Agnès Voisard

Additional information / Pre-requisites

Requirements

  • Course: MafI1 - Logic and Discrete Mathematics
  • Course: ALP1 - Functional Programming or Informatik A
  • Course: ALP2 - Object-oriented Programming or Informatik B
close

Comments

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, 2017-07-20 14:00 - 16:00
Klausur

Location:
HFB/A Hörsaal (Garystr. 35-37)
HFB/B Hörsaal (Garystr. 35-37)
HFB/D Hörsaal (Garystr. 35-37)
Hs 1a Hörsaal (Habelschwerdter Allee 45)
T9/Gr. Hörsaal (Takustr. 9)

Tue, 2017-10-10 14:00 - 16:00
Nachklausur

Location:
HFB/A Hörsaal (Garystr. 35-37)
HFB/B Hörsaal (Garystr. 35-37)
HFB/C Hörsaal (Garystr. 35-37)
HFB/D Hörsaal (Garystr. 35-37)

Regular appointments

Tue, 2017-04-18 14:00 - 16:00

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

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

Tue, 2017-04-25 14:00 - 16:00

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

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

Tue, 2017-05-02 14:00 - 16:00

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

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

Tue, 2017-05-09 14:00 - 16:00

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

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

Tue, 2017-05-16 14:00 - 16:00

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

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

Tue, 2017-05-23 14:00 - 16:00

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

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

Tue, 2017-05-30 14:00 - 16:00

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

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

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

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

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

Tue, 2017-06-13 14:00 - 16:00

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

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

Tue, 2017-06-20 14:00 - 16:00

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

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

Tue, 2017-06-27 14:00 - 16:00

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

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

Tue, 2017-07-04 14:00 - 16:00

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

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

Tue, 2017-07-11 14:00 - 16:00

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

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

Tue, 2017-07-18 14:00 - 16:00

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

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

Thu, 2017-04-20 14:00 - 16:00

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

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

Thu, 2017-04-27 14:00 - 16:00

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

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

Thu, 2017-05-04 14:00 - 16:00

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

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

Thu, 2017-05-11 14:00 - 16:00

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

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

Thu, 2017-05-18 14:00 - 16:00

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

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

Thu, 2017-06-01 14:00 - 16:00

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

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

Thu, 2017-06-08 14:00 - 16:00

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

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

Thu, 2017-06-15 14:00 - 16:00

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

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

Thu, 2017-06-22 14:00 - 16:00

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

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

Thu, 2017-06-29 14:00 - 16:00

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

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

Thu, 2017-07-06 14:00 - 16:00

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

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

Thu, 2017-07-13 14:00 - 16:00

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

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

Thu, 2017-07-20 14:00 - 16:00

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

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

Subjects A - Z