|
|
 |
Introduction to Database Systems
(Einführung in Datenbanken)
winter term 2005/2006
Contact Hours
News
 | The task sheet of this year's second
exam is online. |
| The results
of the second exam are available. |
Dates
| Lecture
 | Tuesday, 08.15-09.45, AH V, start: October, 25 |
| Thursday, 12:30-14:00, AH VI |
|
| Tutorial
| Monday, 10.00-11.30, AH I, start: November, 7 |
|
| Exam
| Wednesday, February 15, 2006, 10:00 - 12:15, AH I - III |
|
General Information
Lecture
| Course material (use the password announced in the lecture to access
the files)
|
Tutorials
| Slides from Tutorial session 0 |
| Assignment 1 (hand in on
November 7)
|
| Assignment 2 (hand in on
November 14)
|
| Assignment 3 (hand in on November 21)
| Brief summary of
mapping variants for IsA-relations |
|
| Assignment 4 (hand in on
November 28)
|
| Assignment 5 (hand in on
December 6)
| SQL DDL statements for
creating tables, views and triggers |
|
| Assignment 6 (hand in on
December 12)
| The name of the attribute in the
ALL_CONSTRAINTS view that indicates the type of the
constraint is named CONSTRAINT_TYPE. |
| Due to an erroneous driver the "is element of" symbol in the
formula of task 6.4 moved away: if you view the PDF at screen (or
print it out on your own) you will see the correct statement:
 |
| The two sets of functional dependencies F and D given in task
6.3 are actually not equivalent (AD -> EI cannot be inferred
from F).
Take the following set as G = {B -> AC, BD-> EI, AD ->E}
instead. |
| In task 6.4 the assumption (A notin X) does not make much sense,
if X is (erroneously) assumed to be the set of all attributes.
The current version corrects this. |
|
| Assignment 7 (hand in on
December 19) |
| Assignment 8 (hand in on
January 9) |
| Assignment 9 (hand in on
January 16) |
| Assignment 10 (corrected
version, hand in on January 23) |
| Please take a look at the
intermediate results
and contact us if you encounter an error! |
| Assignment 11
Additional material:
|
| Revision lecture:
|
Exam
Second exam
| Date and place:
| April 5, 2006, 10:00-12:15, seminar room Lehrstuhl für
Informatik V |
|
| Results
| Personal
Grades |
| If you want to take a look at our corrections, just come to
my office (6235). |
|
| Task sheet |
First exam
| Date and place:
| February 15, 2006, 10:00-12:15, AH I-III |
|
| The only things you need:
| Pen (and pencil) |
| Student ID + Photo ID |
|
| Language
| Exam is handed out in English and German |
| You can answer in English and German |
|
| Please consider the requisites for participation in the exam as
announced during the first lecture and in the
Structure and Organization
document linked above:
| min 50% points in tutorials |
| active participation in the tutorials |
|
| For preparation the last year's exam
(and the second exam) are available
|
| Results
|
| Task sheet |
Links
|
|
|
|
|
|
