Database Lab

Teaching personnel


Lecturer
Corrector(s)

Formalia


Targeted audience
  • DAI Hauptstudium with 8 credit points : in Kombination mit der
    2SWS Vorlesung aus dem Wintersemester als "Datenbanken mit Anwendungen" im Bereich "D"
  • ISE Bachelor

Dates


Tutorials

Date

Time

Place

Tutor

Monday 16:15 - 18:45LF/230Dr.-Ing. Dipl.-Inform. Sascha Kriewel
Tuesday 15:15 - 17:45LF/230Dr.-Ing. Dipl.-Inform. Sascha Kriewel

Description


  • The practical course "Database Lab" is offered for students of "Applied Informatics" (DAI), "Computer Science and Communications Engineering" (CSCE) and "Computer Engineering" (CE). For students of CSCE and CE it is part of the lecture Data Models and Databases in the module Multimedia and Internet. For students of DAI it is part of the lecture Databases with Applications in area D.
  • The teaching language is German.
  • 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. Basic knowledge of database systems will be assumed.

Lecture material


Status of your assignments

  • During the semester you will be able to query your current point total and missing assignments from this webpage.

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

Procedure and requirements


  • 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).
  • For ISE 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.
  • DAI students (area D) will have to write the exam for the 'Database' lecture and will carry the points from the practical course over to the exam (maximum 50 points from the practical course, total number of points with exam: 140).
  • You can work on the assigned tasks in groups of at most 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.

Contact


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