Module Handbook

  • Dynamischer Default-Fachbereich geändert auf INF

Course INF-21-46-K-7

DB Scheme Design and Programming (Project) (4L, 8.0 LP)

Course Type

SWS Type Course Form CP (Effort) Presence-Time / Self-Study
- K 8.0 CP 184 h
4 L Programming training course 56 h
(4L) 8.0 CP 56 h 184 h


CP, Effort 8.0 CP = 240 h
Position of the semester 1 Sem. in SuSe
Level [7] Master (Advanced)
Language [EN] English
Area of study [INF-INSY] Information Systems
Livecycle-State [NORM] Active


Das Modul wurde früher unter der Bezeichnung ORDB-Schemaentwurf und -Programmierung angeboten.

Possible Study achievement

  • Verification of study performance: presentation
  • Examination number (Study achievement): 62146 ("Project DB-Schema Design and Programming")
  • Details of the examination (type, duration, criteria) will be announced at the beginning of the course.


  • Survey of relevant functionality of PostgreSQL (or any other ORDBMS), its components and extensions needed for writing complex database queries (SQL, JSON, XQuery, etc).
  • Analysis and documentation of the given object-relational schemas.
  • Design and development of complex SQL queries, functions, procedures, views, and triggers for the given object-relational DB requirements.
  • Development of a web-based standalone application using an enterprise Java application framework.
  • Database design and schema modeling for the given application from semi-structured datasets.
  • Transformation, cleaning, loading, and indexing of the application data.
  • Session management, caching, and performance improvements using NoSQL data stores.
  • OLAP and Business Analytics on real-world datasets.


  • see Database Systems
  • further material related to the applied technologies and products will be provided

Requirements for attendance (informal)


Requirements for attendance (formal)


References to Course [INF-21-46-K-7]

Module Name Context
[INF-21-46-M-7] DB Scheme Design and Programming (Project) P: Obligatory 4L, 8.0 LP
Course-Pool Name
[INF-INSY_P-KPOOL-7] Projects of the teaching area Information Systems