Lecture “Relational Database Systems 1”

Information
Classification: 
Bachelor Informatik / Wirtschaftsinformatik
Credits: 
5
Exam: 
written at March 7, 2014, 8:30 AM – 10:00 AM
Regular Dates: 
Thursdays, 15:00 – 17:30, PK 2.2
tutorial group dates are given below
Contents
Contents: 

 

Summary: 

 

Materials

 

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!

Summary

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.

Tutorial Groups

  Day Time Room Hiwi Email
1 Tuesday 11:30 – 13:00 IZ 160 Philipp Czora gruppe1atifis [dot] cs [dot] tu-bs [dot] de
2 Tuesday 13:15 – 14:45 IZ 160 Timo Günther gruppe2atifis [dot] cs [dot] tu-bs [dot] de
3 Tuesday 15:00 – 16:30 RR 58.3 Fabian Löhr gruppe3atifis [dot] cs [dot] tu-bs [dot] de
4 Tuesday 15:00 – 16:30 BW 74.5 Philipp Czora gruppe4atifis [dot] cs [dot] tu-bs [dot] de
5 Tuesday 16:45 – 18:15 BW 74.4 Dominik Krupke gruppe5atifis [dot] cs [dot] tu-bs [dot] de
6 Wednesday 8:00 – 9:30 IZ 160 Jennifer Sieg gruppe6atifis [dot] cs [dot] tu-bs [dot] de
7 Wednesday 9:45 – 11:15 IZ 358 Jan-Christoph Kalo gruppe7atifis [dot] cs [dot] tu-bs [dot] de
8 Wednesday 16:45 – 18:15 RR 58.2 Sina Winsmann gruppe8atifis [dot] cs [dot] tu-bs [dot] de

Schedule

  Date Topic Slides Exercises Videos Comments
1 24.10.2013 Introduction Slides 1 Exercise 1 Video 1  
2 31.10.2013 Data Modeling 1 Slides 2 Exercise 2 Video 2  
3 07.11.2013 Data Modeling 2 Slides 3 Exercise 3 Video 3  
4 14.11.2013 View Integration Slides 4 Exercise 4 Video 4 Constraint grouping has been accidentally removed from the lecture. Please refer to last year's video.
5 21.11.2013 Relational Model Slides 5 Exercise 5 Video 5  
6 28.11.2013 Relational Algebra updated Slides 6 (Dec. 4) Exercise 6 Video 6 This lecture's video is an homage to the silent film era – if you demand audio please refer to last year's video.
7 05.12.2013 Relational Calculus Slides 7 Exercise 7   Unfortunately the video file came out broken. But again, there is last year's video.
8 12.12.2013 SQL 1 Slides 8 Exercise 8 Video 8 The due date for Exercise 8 is wrong – it should read: due by Thursday, December 19, 2013.
9 19.12.2013 SQL 2 Slides 9 Exercise 9 Video 9  
10 09.01.2014 Normalization Slides 10 Exercise 10 Video 10  
11 16.01.2014 Application Programming 1 Slides 11 updated Exercise 11 (Jan. 17) Video 11  
12 23.01.2014 Application Programming 2 Slides 12 Exercise 12   A small error has crept in: Exercise 12 has a total of 36 points.

Please refer to last year's video again.
13 30.01.2014 Object Persistence Slides 13   Video 13  
14 06.02.2014 Active Databases Slides 14   Video 14