Weekly notes / Slides
| Week | 05 | 06 | 07 | 08 | 09 | 10 | 11 |
|---|---|---|---|---|---|---|---|
| Weekly notes | 27.01.2012 | 03.02.2012 | 10.02.2012 | ||||
| Slides | 01.02.2012 02.02.2012 | 08.02.2012 | |||||
| Note | The slides are in parts based on slides by Jeffrey D. Ullman and Hector Garcia-Molina. | ||||||
Project
Description
Information about the project is now available in the project description.
Details about the database server will be published here soon.
Preliminary Schedule
| Week | 05 | 06 | 07 | 08 | 09 | 10 | 11 |
|---|---|---|---|---|---|---|---|
| Tue 14-16 (U151) | Exercise | Exercise | Exercise | Exercise | Exercise | Exercise | |
| Wed 10-12 (U151) | Lecture | Lecture | Lecture | Lecture | Lecture | Lecture | |
| Thu 14-16 (U151) | Lecture | Exercise | Lecture | Exercise | Lecture | Exercise | Lecture |
| Fri 14-16 (U151) | Lecture | ||||||
| Fri 12-14 (U151) | Exercise |
Office Hours
Just come to my office. If you want to make sure I'm there, contact me before (by e-mail, jabber, phone).
- Office: IMADA, Ø13-602b-2 (map)
- Phone: 6550 2327
- E-mail: petersk@imada.sdu.dk
- Home page: http://www.imada.sdu.dk/~petersk/
- Jabber: petersk@jabber.dk
Literature
Obligatory course book:
[1] Hector Garcia-Molina; Jeffrey D. Ullman; Jennifer Widom: Database Systems: The Complete Book. Prentice Hall, 2008.
Course Description
Prerequisites:
The content of DM502 Programming A and DM503 Programmering B must be known.
Evaluation:
Project and 1-day take-home exam, for which one combined grade is given. Project and take-home exam count equally in the grade. Grades according to the 7-point marking scale. External examiner.
Examination when the course has been taught. Re-examination after 4th quarter. The re-examination is an oral exam, grades according to the 7-point marking scale, internal examiner.
Withdrawal date:
Withdrawal from the exam must be 7 days before the first exam date.
Course type:
Lectures (22 hours), discussion sessions (20 hours), project work.
Teaching period:
3rd quarter, spring 2012
Aims:
To give the student theoretical skills and practical experience in the use, design, and implementation of a relational database.
Synopsis:
Relational databases, database design (ER-modelling, normal forms), relational algebra, SQL, database access from application programs, basic disk structure, index use and index implementations (hashing based, tree based).
Aim description:
After the course, the student is expected to be able to:
- design a suitable ER-model for a database, on the basis of a problem description
- transform an ER-model for a database into a suitable relational model
- write SQL queries for a relational database
- optimize a relational database through choice of indexes, use of equivalent SQL-expressions, and use of the theory of normal forms
- access a database from an application program
- describe work done on the above subjects in clear and precise language, and in a structured fashion