IMPORTANT:
There was an mistake in the assigment! Please download the new version of the assignement!
IMPORTANT ! ! !
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.
Summary
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.
Registration
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.
Assignments
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
(…@ifis.cs.tu-bs.de) |
| 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 |
.gif)
