DB Project


The goal of the practical course is to develop skills in the design of object-relational DB schemas and the development of modern database applications. The work is divided into four worksheets, focusing on the following concepts:

  1. Sheet: Writing SQL queries and UDFs and development of an embedded-SQL program
  2. Sheet: Implementing a stock trading system using views, triggers, and stored procedures
  3. Sheet: Interacting with the metadata catalog and mapping between relational and XML schemas
  4. Sheet: Implementing the core engine of a web application for onling shopping using servlets

In average, the worksheets are released every two weeks, and each has a submission deadline of 4 weeks after its release.
Students will be organized into groups of two, and the grading of worksheets is performed on a group basis

Additional to the worksheets, there will be three oral examinations (colloquiums), whose goal is to assess the correct understanding of the concepts used in the worksheets. The examinations are performed with both group members, but contrary to the worksheets, the grading is individual. More details will be provided in the kick-off meeting




Apr. 23, 2019

Kickoff Meeting was held, Slides can be found below.

Feb. 28, 2019

Registration for the DB project starts now.


Registration due: April 5 (no extensions. Late submissions will not be considered.).

More details about the registration process are described below.

Details about the Registration Process

  • The number of participants is limited. Registration result does not depend on the first-come-first-serve rule.
  • To register, download this json template registration file, rename it to yourmatriculationnumber.json, edit it to reflect your information and send it as attachment via email to Michael Hohenstein (hohenstein@cs.uni-kl.de). Please use your offcial university email account @cs.uni-kl.de or @rhrk.uni-kl.de to register and to send the email.
  • The registration due is April 5 and the results will be notified several days later in the same week.
  • A kick-off meeting will take place on April 23 (Tuesday) at 11:45 in room 36-336.  In this meeting, we will form the groups, discuss organizational aspects, provide reference material for documentation, and introduce the development environment. The participation in this meeting is mandatory.

Link to the DB-Project Wiki


Exercise Sheet



Contact Person

Michael Hohenstein 36-340