Lab “SQL”

Bachelor Informatik / Wirtschaftsinformatik
4 or 5 (depending on course of study and exam regulations)
Regular Dates: 
Tue 13.15 - 14.45 (IZ 160, PK 3.3)
Tue 15.00 - 16.30 (PK 11.5, RR 58.4)
Wed 13.15 - 14.45 (SN 23.2)
Wed 15.00 - 16.30 (PK 3.4)
Wed 16.45 - 18.15 (PK 3.3)


There was an mistake in the assigment! Please download the new version of the assignement!


All questions regarding the SQL lab can be posed during the first tutorial / lab groups (8.11. / 9.11). In the meanwhile, if you have any questions regarding the SQL lab, which are not already answered on this page please contact Sascha Tönnies.


This lab provides an introduction into the database query language SQL. During the semester, each participant will get assigned a series of homework assignments, which cover the major topics of the lecture Relational Database Systems 1. Participants are required to work together in fixed teams of two.

During the semester, weekly lab sessions will be held in small groups every Tuesday and Wednesday.

This lab replaces the old “SQL-Demokurs.” Note that these two labs are mutually exclusive, that is, you (usually) cannot use the credits of both in your course of study. However, you can replace the Demokurs's credits (if you already got some) by the SQL lab's credits. For details, please consult your Studienordnung/Prüfungordnung.

A note to diploma students: You can use either the SQL lab (4 SWS) or the lecture RDB1 (3 SWS) as part of your Diplomprüfung. However, since both courses are so similar, the exam will always be about the material of both courses.


A registration for one of the courses is necessary. We will hang out lists at our institute's whiteboard after the first lecture of RDB 1 on 27.10.2011. More details will be announced in the first lecture of RDB 1.


During the SQL lab, there will be five assignments to be worked on; the results of each team have to be handed in and will be graded by the team’s tutor. There will be three possible grades: “+1” (good), “0” (average), and “−1” (incomplete, insufficient, or missing). To successfully pass the SQL lab, the sum of all five grades must be positive and each assignment must be delivered.

Number Date Topic Due to Material
1  10.11.2011 Modeling  22./23.11.2011 Task 1
2  24.11.2011 Integration  13./14.12.2011 Task 2, Model 1, Model 2
3  15.12.2011 SQL  10./11.01.2012 Task 3
4  12.01.2012 Relation Model (SQL 2)  24./25.01.2012 Task 4
5  26.01.2012 Application Programming  07./08.02.2012 Task 5

Teams and Groups

Each team of two is assigned to exactly one of the following groups:

Group ID Day and Time Room Tutor Tutor’s E-Mail Address
1 Tuesday, 13.15 – 14.45 IZ 160
 Remo  gruppe1
2 Tuesday, 13.15 – 14.45 PK 3.3
 Simon  gruppe2
3 Tuesday, 15.00 – 16.30 PK 11.5  Phil  gruppe3
4 Tuesday, 15.00 – 16.30 RR 58.4
 Simon  gruppe4
5 Wednesday, 13.15 – 14.45 SN 23.2
 Sebastian  gruppe5
6 Wednesday, 15.00 – 16.30 PK 3.4
 Patrick  gruppe6
7 Wednesday, 16.45 - 18.15 PK 3.3  Philipp  gruppe7


sql-ws1112-aufgabe01.pdf459.46 KB
sql-ws1112-model1.pdf974.75 KB
ChemicalDigitalLibrary.svg666.05 KB
sql-ws1112-aufgabe02.pdf783.7 KB
sql-ws1112-aufgabe03.pdf868.42 KB
sql-ws1112-aufgabe04.pdf255.81 KB
sql-ws1112-aufgabe05.pdf398.53 KB