Lab “SQL”

Bachelor Informatik / Wirtschaftsinformatik
4 or 5 (depending on course of study and exam regulations)
Regular Dates: 
refer to Lab Groups table



Please note: The due date for the last assignment has been moved to (29|30).01.2013, so you have one more week to hand it in. This was necessary because it is based on knowledge from a later RDB1 lecture (Application Programming 2, which is held on 17.01.2013). This also implies changes to the last meeting, which is now on (29|30).01.2013. If you are unable to attend to the last meeting, please inform your tutor. We apologize for any inconvenience!

Participants of this lab will work with relational databases. Each participating team will get five homework assignments, which cover the practical parts of Relational Database Systems 1. Participants have to work in fixed teams of two. Biweekly lab sessions will be held in small lab groups (integrated in the RDB1 tutorial groups) every Tuesday and Wednesday. Participation in these lab groups is mandatory.

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 for 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 Lab groups is necessary. We will provide lists at our institute's whiteboard after the first lecture of RDB1 on 18.10.2012. Further details will be announced in the first RDB1 lecture.


There will be five assignments in the SQL Lab for each team. They will be graded by the team’s tutor in three possible ways: +1 (good), 0 (average), and −1 (incomplete or insufficient). To successfully pass the SQL Lab the sum of all five grades must be positive and each assignment must be handed in.

Lab groups

No. Day Time Room Tutor Email
1 Tuesday 13:15 Uhr - 14:45 Uhr IZ 160 Martyna gruppe1atifis [dot] cs [dot] tu-bs [dot] de
2 Tuesday 13:15 Uhr - 14:45 Uhr RR 58.2 Sina gruppe2atifis [dot] cs [dot] tu-bs [dot] de
3 Tuesday 15:00 Uhr - 16:30 Uhr PK 14.7 Raimund gruppe3atifis [dot] cs [dot] tu-bs [dot] de
4 Tuesday 15:00 Uhr - 16:30 Uhr BW 74.3 Philipp gruppe4atifis [dot] cs [dot] tu-bs [dot] de
5 Tuesday 16:45 Uhr - 18:15 Uhr PK 3.1 Jan gruppe5atifis [dot] cs [dot] tu-bs [dot] de
6 Tuesday 16:45 Uhr - 18:15 Uhr RR 58.3 Philipp gruppe6atifis [dot] cs [dot] tu-bs [dot] de
7 Wednesday 13:15 Uhr - 14:45 Uhr PK 3.4 Leonhard gruppe7atifis [dot] cs [dot] tu-bs [dot] de
8 Wednesday 13:15 Uhr - 14:45 Uhr PK 14.6 Markus gruppe8atifis [dot] cs [dot] tu-bs [dot] de
9 Wednesday 15:00 Uhr - 16:30 Uhr BW 74.4 Yevgen gruppe9atifis [dot] cs [dot] tu-bs [dot] de
10 Wednesday 16:45 Uhr - 18:15 Uhr PK 3.3 Vincent gruppe10atifis [dot] cs [dot] tu-bs [dot] de
  Date Topic Due date Material
1 (06|07).11.2012 Modellierung (20|21).11.2012
[file] Organisatorisches.pdf [file] Modellierung.pdf
[file] Szenario-A.pdf [file] Szenario-B.pdf
2 (20|21).11.2012 Integration (04|05).12.2012
[file] Integration.pdf
3 (04|05).12.2012 SQL 1 (18|19).12.2012
[file] Data-Definition.pdf (UPDATED on 10.12.)
[file] NetFirst.pdf (UPDATED on 10.12.)
4 (18|19).12.2012 SQL 2  (08|09).01.2013
[file] Data-Manipulation.pdf [file] Three-Degrees.pdf
5 (08|09).01.2013 Application Programming (29|30).01.2013
[file] Application-Programming.pdf [file] SQL-Statements.pdf
6 (29|30).01.2013 Last meeting    


File Organisatorisches.pdf26/10/12 4:31 pm57.84 KB
File Modellierung.pdf05/11/12 6:53 am68.88 KB
File Szenario-B.pdf05/11/12 4:54 pm64.06 KB
File Szenario-A.pdf05/11/12 4:54 pm63.1 KB
File Integration.pdf20/11/12 10:02 am509.51 KB
File Data-Definition.pdf10/12/12 12:18 am648.14 KB
File Net-First.pdf10/12/12 12:31 am663.85 KB
File Data-Manipulation.pdf17/12/12 7:42 pm89.65 KB
File Three-Degrees.pdf17/12/12 7:42 pm289.27 KB
File Application-Programming.pdf15/01/13 4:19 pm126.05 KB