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)

Basedata

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

Notice

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

Courses

Type/SWS Course Number Title Choice in
Module-Part
Presence-Time /
Self-Study
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
PRAES
- 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)..


Contents

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

Literature

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

Requirements for attendance of the module (informal)

None

Requirements for attendance of the module (formal)

None

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