Lecture “Relational Database Systems 1”

Information
Classification: 
Bachelor Informatik / Wirtschaftsinformatik
Credits: 
4 or 5 (depending on your course of study and exam regulations)
Exam: 
The repeat exam in SS13 will be written on September 4th between 8:30 and 10:00 in the Audimax
Regular Dates: 
Thursday, 15:00-17:30, in room PK2.2
see below for the tutorial groups dates
Contents
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). Note that lectures and exercises are not separated like in similar courses but interlaced where adequate.

If you are attending this lecture please sign up to our HMS System where you can keep track of your up-to-date homework scores. 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 give you the remaining 4 credit points. These two parts could be done independently but you need to pass both parts to complete the module.

Please note: 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 mailbox 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 at (30|31).10.2012 (third course week).

Repeat Exam:
The repeat exam in SS13 will take place on September 4th between 8:30 and 10:00 in the Audimax.

Post-exam review:
The post-exam review for the exam in SS13 will take place on September 12th between 14:30 and 17:00 in the Room IZ 251.

Tutorial groups

No. Day Time Room Hiwi 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

 

Materials
  Date Topic Slides Exercises Videos Comments
1 18.10.2012 Introduction Slides01 Exercise01 Video01  
2 25.10.2012 Modeling 1 Slides02 Exercise02 Video02  
3 01.11.2012 Modeling 2 Slides03 Exercise03 Video03  
4 08.11.2012 View Integration Slides04 Exercise04 Video04  
5 15.11.2012 Relational Model Slides05 Exercise05 Video05  
6 22.11.2012 Relational Algebra Slides06 Exercise06 Video06   
7 29.11.2012 Relational Calculus Slides07 Exercise07 Video07   
8 06.12.2012 SQL 1 Slides08 Exercise08 Video08  
9 13.12.2012 SQL 2 Slides09 Exercise09 Video09  
10 20.12.2012 Normalization Slides10 Exercise10 Video10  
  27.12.2012          
  03.01.2013          
11 10.01.2013 Application Programming 1 Slides11 Exercise11 Video11  
12 17.01.2013 Application Programming 2 Slides12 Exercise12 Video12  
13 24.01.2013 Object Persistence Slides13   Video13  
14 31.01.2012 Active Databases Slides14   Video14