Database Lab

Dates


Tutorials

Date

Time

Place

Tutor

Monday 10:00 - 13:00LF/230Tobias Tuttas
Tuesday 12:00 - 15:00LF/230Dipl.-Inform. Gudrun Fischer
Thursday 10:00 - 13:00LF/230Camille Pieume

Description


  • The practical course "Database Lab" is offered for students of "Computer Science and Communications Engineering" (CSCE) and students of "Computer Engineering" (CE). It is part of the lecture Data Models and Databases in the module Multimedia and Internet. The teaching language is German (exception: on Thursday, we have an English-speaking tutor). In weekly practical exercises, we will use IBM's DB2 database system to solve the different stages of a complex example problem (case study).
  • Students who plan to take part in the Database Lab will need the knowledge from the Database lecture. Participants who have not yet attended the Database lecture, should do so in this semester. In addition, we also recommend the exercises accompanying the lecture.

Lecture material


Status of your assignments

  • Here, you can check the status of your homework and practical assignments for each (past) week. It may take us up to a week, however, to add the assignments of each current week, so please be patient. If you have any questions about the status of your assignments, please ask your tutor.

Course material

Previous exams

  • Datenmodelle und Datenbanken I / Internetdatenbanken (WS 03/04)
  • Datenmodelle und Datenbanken I / Internetdatenbanken (SS 04)
  • Datenmodelle und Datenbanken I / Internetdatenbanken (Probeklausur)
  • Datenmodelle und Datenbanken II (WS 03/04)
  • Datenmodelle und Datenbanken II (SS 04)
  • Datenmodelle und Datenbanken II (WS 04/05)
  • Datenmodelle und Datenbanken II (Übungsaufgaben)

Tools

Literature

Databases

  • A. Kemper, A. Eickler: Datenbanksysteme. Eine Einführung. 4. Auflage, Oldenbourg, 2001.
  • J. Biskup: Grundlagen von Informationssystemen. Vieweg, 1995.
  • R. Elmasri, S.B. Navathe: Fundamentals of Database Systems. Benjamin/Cummings, Redwood City etc.
  • W. Kießling, G. Köstler: Multimedia-Kurs Datenbanksysteme, Springer.
  • J.D. Ullmann: Principles of Database and Knowledge-Base Systems, Volume I and II, Computer Science Press.
  • A. Heuer, G. Saake: Datenbanken - Konzepte und Sprachen. MITP-Verlag, Bonn.
  • G. Vossen: Datenmodelle, Datenbanksprachen und Datenbank-Management-Systeme. Addison-Wesley.
  • Th. Härder, E. Rahm: Datenbanksysteme: Konzepte und Techniken der Implementierung. Springer.

IBM DB2, SQL

Java, JDBC

Unix, Linux

Registration and first lab date


Procedure and requirements


  • As this practical course requires knowledge from the database lecture, which can be attended in this semester, the lab course will start only in the second third of the semester, in the week beginning with May 8th. All in all, the course will require 10 * 3 hours of presence and active participation, as well as autonomous preparation and wrap-up on your part, at home. This corresponds to 2 lecture hours per week (15 weeks * 2 hours = 10 weeks * 3 hours).
  • The course will not be graded. Your participation will be certified if you participate on a regular basis (at least 8 of 10 weeks) and work on the assigned tasks. All assignments must be solved. We expect you to solve an assignment in the exercise immediately after it has been issued. If you do not succeed in solving all assignments, you can try to amend maximally two of them in an additional exercise. We expect you to record your solutions and results in an exercise log.
  • You can work on the assigned tasks in groups of maximally 2 students. At least one person per group should understand German, so that your group will be able to understand the German course material and task descriptions. Each group is expected to work autonomously, without outside help or coaching. We will form these groups on the first lab date, so please be sure to attend.

Auxiliary lab day


In case you missed a lab day, or if you could not finish a practical assignment during the regular hours, we offer additional lab time on each Wednesday between 11:00 and 14:00 h, in LF 230. Please notify Tobias Tuttas (by e-mail, until Tuesday 18:00 h), so that he can open the lab for you and sign your completed assignments afterwards.

Klausuren


Die Klausuren zu den Lehrveranstaltungen

  • Datenbanken (DAI, 12 KP)
  • Datenbanken und Anwendungen (DAI, 8 KP)
  • Datenmodelle und Datenbanken (AOS, ISE)
  • Datenbanken, Informationssysteme und Information Retrieval (Kommedia, neue PO)

finden am 03.08.2006 ab 08:30 Uhr im Audimax (LA) statt.

Es sind keine Hilfsmittel zugelassen (ausgenommen ein normales, zweisprachiges Wörterbuch).

Zeiten:

  • Datenbanken (DAI, 12 KP)
    08:30 bis 10:00 Uhr
  • Datenbanken mit Anwendungen (DAI, 8 KP)
    08:30 bis 10:00 Uhr
  • Datenmodelle und Datenbanken I (AOS)
    08:30 bis 10:00 Uhr
  • Datenmodelle und Datenbanken II (AOS)
    08:30 bis 10:00 Uhr für diejenigen, die nur diese Klausur schreiben
    10:00 bis 11:30 Uhr für diejenigen, die am selben Tag auch "Datenmodelle und Datenbanken I" schreiben wollen
  • Datenmodelle und Datenbanken (ISE)
    08:30 bis 10:00 Uhr
  • Datenbanken, Informationssysteme und Information Retrieval (Kommedia, neue PO, bitte auch per E-Mail anmelden!)
    08:30 bis 10:00 Uhr

Anmeldung zur Klausur:

  • Die Anmeldung für die Studiengänge DAI, ISE, AOS und Kommedia erfolgte über das Prüfungsamt.
  • Kommedia-Studierende, die schon nach der neuen PO studieren, dürfen die Klausur in diesem Semester wahlweise über 2+1 oder über 4+2 Semesterwochenstunden schreiben. Aus organisatorischen Gründen bitten wir Kommedia-Studierende daher, sich (bis zum 24.07.2006) zusätzlich auch per E-Mail bei uns anzumelden: db06@is.inf.uni-due.de
  • Studierende anderer Studiengänge melden sich bitte unbedingt bis zum 24.07.2006 per E-Mail an: db06@is.inf.uni-due.de

Contact


  • If you have any questions or problems in the context of this course, then please come to Gudrun Fischer's consulting hours. You will find the hours and the room number on her homepage.
  • You can also contact all three members of the teaching personnel for this course via e-mail: dbpraktikum@is.inf.uni-due.de