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

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!):

Teams and Groups

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