|  |  | | Database Lab - Practical course,
Summer 2008
|  |
Teaching personnel- Lecturer
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
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.
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
Additional 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
- The course will use the computer pool of the chair of
Information Systems. The necessary login account will be
given out during the first session.
- The computers use the GNU/Linux operating system. A
short introduction with first steps under Linux will be
given in the first week of the course.
- Week 1: Organisation,
Exercises: First steps with Linux and DB2,
Additional Material: First steps under
Linux
- Week 2: Vorbereitung:
Modellierung in E/R und UML, Präsenz: DB2-Struktur,
Zugriffsrechte, Anlegen der eigenen Datenbank
- Week 3: Vorbereitung:
Relationenschema, Schlüssel und Normalformen, Präsenz: DB2-Datenbank-Manager,
Anlegen von Tabellen
- Week 4: Ändern und Füllen von
Tabellen, Pflege von Tabelleninhalten
- Week 5-6: SQL als
Anfragesprache
- Week 7: Rekursive Anfragen, Trigger
und SqlPl
- Week 8: Datenbank-Anwendung mit Apache2 und PHP
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
| | |
| | |
DEUTSCH