Studies

193
Compulsory

When a course instance has been created from a template, the course instance will be in this state

  • Data is usually still incomplete and everything can still be edited.
  • Lecturers or secretaries can move the state forward to Edited.

Inhalt

Datenbankentwurf mit ER / UML. Theoretische Grundlagen Relationaler Datenbanksysteme: relationale Algebra, Funktionale Abhängigkeiten, Normalformen. Relationale Datenbankentwicklung: SQL Datendefinition, Fremdschlüssel und andere Integritätsbedingungen. SQL als applikative Sprache: wesentliche Sprachelemente, Einbettung in Programmiersprachen, Anwendungsprogrammierung; objekt-relationale Abbildung. Sicherheits- und Schutzkonzepte.

Technik: Transaktionsbegriff, transaktionale Garantien, Synchronisation des Mehrbenutzerbetriebs, Fehlertoleranzeigenschaften. Anwendungen und neue Entwicklungen: Data Warehouse-Technik, Data-Mining, Information Retrieval / Suchmaschinen. Im begleitenden Projekt werden die Themen praktisch vertieft.

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.

Cross-language

193 015
Compulsory

Expectant Mother

Not dangerous
Partly dangerous
Alternative Course
Dangerous
Show questionnaire

Nursing Mother

Not dangerous
Partly dangerous
Alternative Course
Dangerous
Show questionnaire

AncillaryCourses

Übung zu Datenbanksysteme

Expectant Mother

Not dangerous
Partly dangerous
Alternative Course
Dangerous
Show questionnaire

Nursing Mother

Not dangerous
Partly dangerous
Alternative Course
Dangerous
Show questionnaire