184.790 Data Modelling 2
This course is in all assigned curricula part of the STEOP.
This course is in at least 1 assigned curriculum part of the STEOP.

2021W, VU, 2.0h, 3.0EC


  • Semester hours: 2.0
  • Credits: 3.0
  • Type: VU Lecture and Exercise
  • Format: Distance Learning

Learning outcomes

After successful completion of the course, students are able to

  • devise mechanisms for guaranteeing given integrity constraints in a relational schema and to implement them in SQL on a relational database management system (RDBMS);
  • comprehending and developing database queries using advanced SQL language features;
  • develop and apply procedures in a procedural database programming language;
  • evaluate properties of parallel transactions and to identify problems caused by parallel processing of transactions;
  • systematically apply different isolation levels;
  • execute and understand the presented methods and concepts for recovery and concurrency control.

Subject of course

  • Database programming (with pgSQL)
  • SQL-extensions
  • Transactions
  • error handling / recovery
  • concurrency control

Teaching methods

  • This course will be held in a distance-learning format.
  • This course is offered in a blocked format: the recordings will be put online on Mondays and Wednesdays. The lecture part (not the exercises) will end on December 1, 2021.
  • This course will be held both in English and in German: the lectures, the exercise, and the exams will be available in both languages.
  • The topics of the course are presented during the lectures.
  • In the exercise part of the course, the application of the presented methods, concepts, and algorithms are trained.
  • The exercise part consists of exercise sheets, which are solved by the students as homework and handed in.
  • Practicing the formulation of SQL queries is done in an online tool.
  • Ahead of the deadlines questions can be asked in the forum, teaching assistants will answer them there.
  • Exercises are discussed and checked by teaching assistants.


Mode of examination


Additional information


This course is only for student who already passed the course "Data Modelling" and as part of the transitional regulations for the degree course scheme starting in 2017 are not required to take the full course "Database Systems", which now includes all of the content of "Data Modelling".

ECTS Breakdown:

15h   lectures (1h preliminary meeting, 14h lectures)
14h preparation for and repetition of lectures
26h solving exercise sheets
0,5h exercise interview
18h exam preparation
 1,5h exam
75h (= 25h * 3ECTS)



Examination modalities

The final evaluation is based on the performance at the exercises (evaluation of the first exercise sheet is based on the submission, evaluation of the second exercise sheet also heavily depends on the performance at the meeting with the Tutor) and a written exam.


DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Fri - 21.01.2022written01.01.2022 00:00 - 19.01.2022 12:00TISSTest
Fri - 04.03.2022written11.02.2022 00:00 - 02.03.2022 12:00TISSTest Nebentermin

Course registration

Begin End Deregistration end
12.09.2021 09:00 19.10.2021 23:55 19.10.2021 23:55

Registration modalities

Bitte beachten Sie, dass eine gleichzeitige Anmeldung zu den LVAs Datenbanksysteme oder Datenmodellierung nicht erlaubt sind. Bei Anmeldung zu mehr als einer dieser drei LVAs mit Ende der Anmeldefrist erfolgt eine Abmeldung von allen drei LVAs.

Anmeldungen aller Studierenden aus Informatik und Wirtschaftsinformatik werden bestätigt. Studierende anderer Studien je nach vorhandener Kapazität.



No lecture notes are available.

Previous knowledge

The topics presented as part of the course "Data Modelling" are assumed to be known by the student. They are not recalled or repeated as part of the lectures. If needed, the corresponding lectures of the course "data modelling", which take place before the lecture of the present course, should be visited.

Preceding courses