The post repeat exam review (Klausureinsicht) will take place on September 2nd 2014 from 10:00 to 13:00 in IZ 251.

The repeat exam will take place on August 27th 2014 at 11:30 in the Audimax and is 90 minutes long. Like last semesters, the written exams will be held in German. However, you may answer either in German or in English.

The exam will again be an "Überhangsklausur". All contents from the lecture and the homeworks are relevant for the exam, unless they appeared in a detour and not in a homework. That means: Exercise types that did not appear in the last exam are definitely possible to be asked in the repeat exam.

Please use the following SQL Syntax in the exam (like in the exercises): Use the SQL syntax introduced in the lecture. If the lecture introduces DB2 syntax for an SQL statement that differs from the standard (like the need to use explicit NOT NULL with PRIMARY KEYs), use DB2 syntax.

You are permitted to use two Cheat Sheets in the exam. You may use two hand-written two-sided DIN A4 pages with notes. These are the only resources allowed in the exam besides pen and paper. A calculator will not be necessary.

Exam Language

Like last semesters, the written exams will be held in German (see Diploma Supplement 2.5 in your BPO). For legal reasons we cannot provide both, a German as well as an English version of your exam sheets. However, you may answer either in German or in English.

Exam Type

This term's exam will be an "Überhangsklausur". This means: It will intentionally contain more exercises than the average student will be able to complete in the given time. This is to your advantage: You can start with the exercises you know best and do harder exercises later. You can leave out the hardest exercises alltogether, because we don't expect you to complete all. However, this concept only works if you prepare for all exercise types (no "auf Lücke lernen") and try to process and complete as much exercises as possible.

Exam Content

All contents from the lecture and the homeworks are relevant for the exam, unless they appeared in a detour and not in a homework.

Exam SQL Syntax

Please use the following SQL Syntax in the exam (like in the exercises): Use the SQL syntax introduced in the lecture. If the lecture introduces DB2 syntax for an SQL statement that differs from the standard (like the need to use explicit NOT NULL with PRIMARY KEYs), use DB2 syntax.

Exam Cheat Sheets

You will be permitted to use two Cheat Sheets during the exam. You may use two hand-written two-sided DIN A4 pages with notes. These are the only resources allowed in the exam besides pen and paper. A calculator will not be necessary.

Exam Details

The exam will be written on March 7, 2014, from 8:30 AM until 10:00 AM. Room allocations will be announced around March 5 on this website.

Exam Rooms

The room will be determined by your matriculation number:

• All students with a matriculation number ending with a 1 or 2 will write the exams in PK 11.2.
• All students with a matriculation number ending with a 3 or 4 will write the exams in PK 11.3.
• All students with a matriculation number ending with any other number (5,6,7,8,9,0) will write the exams in the Audimax.

Results and Post-Exam Review

The exam has been corrected and the exam results are expected to be posted on Monday (March 10). The post-exam review will be held in room IZ 251 (Seminar Room) at Thursday (March 13) from 3pm to 6pm.

A registration page for the tutorial groups will be unlocked at http://www.ifis.cs.tu-bs.de/teaching/ws-1314/tutorials after the first RDB1 lecture.

If you need to hand in homework, please sign up to our Homework Management System!

This course provides an introduction to relational databases. We strongly encourage Bachelor Informatik or Bachelor Wirtschaftsinformatik students to participate in the accompaning SQL Lab (which will focus on some of the practical lecture topics). This course is a module consisting of two parts. The first part will grant you 1 credit point for getting at least 50% of all homework points. Passing the exam at the end of the semester will grant you 4 credit points. You need to pass both parts to complete the module.

Your homework has to be turned in until the due date indicated on top of the the current assignment, before the lecture starts. Please work together in groups of two students, larger groups are not permitted. Write your names and matriculation numbers on each page of your homework. If you have multiple pages, staple them together! Please drop your solutions into the homework box at our institute (Informatikzentrum, second floor, next to room 238) or hand them over to us right before the lecture begins. The tutorial groups will start in the third course week.