19301501
Lecture
SoSe 20: 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
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.
closeSuggested reading
- Alfons Kemper, Andre Eickler: Datenbanksysteme - Eine Einführung, 5. Auflage, Oldenbourg 2004
- R. Elmasri, S. Navathe: Grundlagen von Datenbanksystemen, Pearson Studium, 2005
27 Class schedule
Additional appointments
Tue, 2020-07-07 14:00 - 16:00Klausur: für den Termin ist die Mensa (Speisesaal Mensa II, Reservierungsnr. FU/328593) reserviert.
Tue, 2020-11-03 14:00 - 16:00
Datenbanksysteme Nachklausur
Regular appointments
Tue, 2020-04-14 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-04-21 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-04-28 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-05-05 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-05-12 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-05-19 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-05-26 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-06-02 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-06-09 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-06-16 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-06-23 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-06-30 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-07-07 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Tue, 2020-07-14 14:00 - 16:00
Datenbanksysteme (Serientermin 1)
Thu, 2020-04-16 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-04-23 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-04-30 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-05-07 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-05-14 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-05-28 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-06-04 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-06-11 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-06-18 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-06-25 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-07-02 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-07-09 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Thu, 2020-07-16 14:00 - 16:00
Datenbanksysteme (Serientermin 2)
Content
Database design with ERM/ERDD. Theoretical foundations of relational database systems: relational algebra, functional dependencies, normal forms. Relational database development: ... read more