[News] [Schedule] [Course description] [Links] [Intranet]
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
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:
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) |