Lab “SQL”

Bachelor Informatik / Wirtschaftsinformatik
4 or 5 (depending on examination rules)
Regular Dates: 
Tue 16:45 - 18:15 (RR 58.2, RR 58.4)
Tue 18:30 - 20:00 (SN 23.2)
Wed 08:00 - 09:30 (RR 58.3, RR 58.4)
Wed 11:30 - 13:00 (BW 74.3, BW 74.5, IZ 251)


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

Please note: For Exercise 1: You have to send your solutions via E-Mail to your tutor until the 07./08.12. The date on the printed sheets is not correct.


 Assignments (participation in the group meetings is mandatory!):

Number Date Topic Due to   Material
1 23./24.11.2010 Modeling 07./08.12.2010 Scenario A
Scenario B

2  14./15.12.2010  Integration  04./05.01.2011 Assignment 2
3  04./05.01.2011  SQL   11./12.01.2011 Assignment 3
4  11./12.01.2011 SQL 2  25./26.01.2011 Assignment 4  
5  25./26.01.2011 Application Programming  08./09.02.2011 Assignment 5  

Teams and Groups

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

Group ID Day and Time Room Tutor

Tutor’s E-Mail Address


1 Tuesday, 16.45–18.15 RR 58.2
Sebastian Busse  gruppe1
2 Tuesday, 16.45–18.15 RR 58.4
Patrick Werner  gruppe2
3 Tuesday, 18.30–20.00 SN 23.2

Michael Bier / Vincent Breitmoser

4 Wednesday, 11.30–13.00 IZ 251
Sergej Dechand  gruppe4
5 Wednesday, 08.00–09.30 RR 58.3
Stefanie Breske  gruppe5
6 Wednesday, 08.00–09.30 RR 58.4 Simon Barthel  gruppe6
7 Wednesday, 11.30–13.00 BW 74.3
Anna-Lena Berndt  gruppe7
8 Wednesday, 11.30–13.00 BW 74.5
Nils Dietzsch  gruppe8



Die Scheine für das Praktikum können ab sofort im Sekretariat des IFIS bei Frau Dalkiran im Raum 236 abgeholt werden.

File sql-ws1011-aufgabe01_b.pdf26/11/10 2:23 pm512.17 KB
File sql-ws1011-aufgabe01_a.pdf26/11/10 2:23 pm515.55 KB
File sql-ws1011-aufgabe02.pdf03/01/11 4:47 pm254.29 KB
File sql-ws1011-aufgabe03.pdf04/01/11 7:51 pm608.61 KB
File sql-ws1011-aufgabe04.pdf11/01/11 12:36 pm505.1 KB
File sql-ws1011-aufgabe05.pdf25/01/11 1:07 pm322.13 KB