IT University of Copenhagen

Database Systems, fall 2006

[News] [Schedule] [Course description] [Links] [Intranet]

News

The exam has been corrected (answers). Grades will be available via my.itu. The passing percentage was 83, and the average passing grade 8.3.

Curriculum for the exam.

Note that there is a follow-up course (15 ECTS) on database tuning in spring 2007.

Groups for the project have been made.

The tables used in the course book can be inserted into your database by clicking at this link, copy and paste the text into the SQL*Plus windows. This will create the relations in your database

Schedule

This is a tentative plan. Changes to contents and/or reading material may occur. However, we will strive to make such changes at least a week in advance.

Date Subject Literature Exercises Hand-in
Aug. 29 Introduction (RP) - slides RG 1, 5.2 Ex0 -
Sep. 5 ER modeling (RP) - slides RG 2, note Ex1 -
Sep. 12 The relational model (RP) - slides RG 3 Ex2 Individual hand-in 1
Sep. 19 Relational algebra (ERH) - slides RG 4.0-4.2, part of 5 Ex3 -
Sep. 26 No lecture - Group hand-in 1
Oct. 3 SQL (ERH) - slides RG 5 Ex4 -
Oct. 10 DB application development (ERH) - slides RG 6 Ex5 Individual hand-in 2
Oct. 17 No lecture (fall break) - -
Oct. 24 Normalization (RP) - slides RG 19.1, 19.2, 19.4, 19.5, 19.6, 19.7, 19.9 Ex6 -
Oct. 31 Transaction management (ERH) - slides RG 16, paper Ex7 Group hand-in 2, note
Nov. 7 Indexing, query processing (ERH) - slides RG 8.1,8.2,8.3,8.5, 12.1,12.2,12.4,12.5,12.6 Ex8 -
Nov. 14 Database tuning (RP) - slides RG 20 Ex9 Individual hand-in 3
Nov. 21 Guest lecture: Martin Jensen, Oracle - -
Nov. 28 Security and authorization (ERH) slides RG 21 Ex10 Group hand-in 3
Dec. 5 Temporal data (slides). Exam info (slides, example). (RP) EM 24.2.0-24.2.2 (hand-out) - -
Jan. 2 Written exam (9.00-13.00), room 3A12+3A14      

Literature:

Links

Teachers

Rasmus Pagh
(lectures, course responsible)
Office: 3C 07
E-mail: pagh@itu.dk
Esben Rune Hansen
(lectures)
Office: 3C 14
E-mail: esben@itu.dk
Knut Tveitane (exercises and hand-ins)
E-mail: knut (@itu.dk)

Martin Scheil Corneliussen (exercises and hand-ins)
E-mail: mscheil (@itu.dk)