Lecture “Relational Database Systems 1” (WS 2009/2010)

Information
Classification: 
Bachelor Informatik / Wirtschaftsinformatik
Credits: 
4
Exam: 
Written (details see below)
Regular Dates: 
Tuesdays, 15:00–17:15, in room PK 11.1; starting on October 27
Contents
Summary: 

This course provides an introduction to relational databases. For students in “Bachelor Informatik” or “Bachelor Wirtschaftsinformatik”, we strongly recommend the (optional) accompanying lab “SQL”.

If you are attending this lecture, please sign up for it in our HMS system. In the HMS, you also can find up-to-date information about the number of points you scored in your homework yet.

Please note: To be admitted to the final exam, you need 50% of all homework points. 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.

Information for “repeaters”: If you fulfilled the lecture's homework requirements in a previous winter semester and took the final exam at least once, you are also admitted to this winter semester's exam. This means that you don't have to fulfill this semester's homework requirements. However, to raise your chances of passing the exam, we highly recommend that you still work on all homework assignments.

Information for diploma students: If you reach at least 50% of the maximum homework score, you can get an Übungsschein (1 SWS), if you need one for your course of study (please let us know in time). If you pass the final exam (being admitted to the exam requires scoring 50% in homework assignments), you get a Vorlesungsschein (3 SWS). For taking an oral Diplomprüfung in information systems, the 50% rule does not apply.

Exam Results

The exam results are now announcement via the board on the ifis floor. Participants, who registered for the lecture in the HMS, also can find their result there.

You may inspect your written exam on Wednesday, February 24, between 10 a.m. and 12 p.m. in room 251.

Exam in Summer Term 2010

The exam in the summer term 2010 will take place on Thursday, September 2, 2010 in room PK 11.1. The exam will begin at 8:30. Please make sure to arrive in time. The regulations regarding “cheat sheets” remain unchanged (see the first slides of Lecture 12).

Note: In response to student feedback on previous exams, the current exam will contain fewer exercises than previous ones. Consequently, the overall workload will be smaller but you cannot skip as many exercises as in previous exams.

Materials

Lectures

Note that lectures and exercises will not be separated. Exercise parts will be interlaced into the lecture whereever adequate.

  Date Contents References Materials
1 27.10.2009 Introduction    
2  3.11.2009 Modeling 1    
3 10.11.2009 Modeling 2    
4 17.11.2009 Integration    
5 24.11.2009 Relational Algebra    
6  1.12.2009 Relational Calculus    
7  8.12.2009 SQL 1    
8 15.12.2009 SQL 2    
9  5. 1.2010 Normalization    
10 12. 1.2010 Application Programming 1    
11 19. 1.2010 Application Programming 2    
12 26. 1.2010 Object Persistence and Object Databases    
13  2. 2.2010 Active Databases    

Student Assistants

Here is a list of all students assistants assigned to this course. That is, these people will grade and comment on your homework. If you have any questions regarding your recent gradings, please ask the responsible assistant directly.

Name E-Mail Address (…@tu-bs.de)
Mahmoud Alfarra m.alfarra
Simon Barthel s.barthel
Anna-Lena Berndt a-l.berndt
Stefanie Breske s.breske
Matthias Britten m.britten
Sebastian Busse se.busse
Carina Flämig c.flaemig