Module Handbook

  • Dynamischer Default-Fachbereich geändert auf INF

Module INF-21-46-M-7

DB Scheme Design and Programming (Project) (M, 8.0 LP)

Module Identification

Module Number Module Name CP (Effort)
INF-21-46-M-7 DB Scheme Design and Programming (Project) 8.0 CP (240 h)


CP, Effort 8.0 CP = 240 h
Position of the semester 1 Sem. in SuSe
Level [7] Master (Advanced)
Language [EN] English
Module Manager
Area of study [INF-INSY] Information Systems
Reference course of study [INF-88.79-SG] M.Sc. Computer Science
Livecycle-State [NORM] Active


This module used to be called 'ORDB scheme design and implementation'


Type/SWS Course Number Title Choice in
Presence-Time /
SL SL is
required for exa.
PL CP Sem.
4L INF-21-46-K-7
DB Scheme Design and Programming (Project)
P 56 h 184 h
- no 8.0 SuSe
  • About [INF-21-46-K-7]: Title: "DB Scheme Design and Programming (Project)"; Presence-Time: 56 h; Self-Study: 184 h
  • About [INF-21-46-K-7]: The study achievement "[PRAES] presentation" must be obtained.

Evaluation of grades

The module is not graded (only study achievements)..


  • 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.

Competencies / intended learning achievements

As a major goal of the project, the participants are made familiar with the most important techniques for the design of a relational database (information requirements analysis, DB-schema design, DB programming), for DB optimization as well as for design and realization of Web-based DB applications.

After successfully completing the module, students will be able to

  • determine basic and extended requirements for a system solution in discussions with users,
  • independently define additional requirements for a system solution according to heuristic criteria
  • divide agreed and self-chosen tasks into subtasks and to work on them together in a cooperative manner,
  • estimate and plan the project effort in detail and to use resources in a goal-oriented way,
  • document and manage work results comprehensively and accurately and to present results
  • present a specialist lecture using suitable media to a heterogeneous specialist audience,
  • lead and moderate a well-founded discussion on the chosen topic based on a technical lecture,
  • assess their own scope for action and decision-making and the associated responsibility and, if necessary, obtain targeted information, define priorities, derive tasks, develop solutions and monitor progress
  • recognize misunderstandings and role conflicts in communication situations at an early stage and to contribute to conflict resolution,
  • argue goal-oriented in controversial discussions and to deal with criticism objectively,
  • participate constructively and actively in heterogeneous working groups,
  • represent independent points of view and, if necessary, points of view that differ from others in a very comprehensible way and to argue plausibly and convincingly.
  • lead, instruct and motivate a working group frequently
  • lead heterogeneously composed groups responsibly and to represent work results to third parties.
  • develop their own professional, methodological, technological, interdisciplinary, social and personal skills independently.


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

Requirements for attendance of the module (informal)


Requirements for attendance of the module (formal)


References to Module / Module Number [INF-21-46-M-7]

Course of Study Section Choice/Obligation
[INF-88.79-SG] M.Sc. Computer Science [Specialisation] Specialization 1 [WP] Compulsory Elective