Introduction to Database Design, Fall 2011Taught by Rasmus Pagh. This page contains the publicly available materials for the course. Access to further resources is available to registered students in LearnIT. See also the official course description. |
Many exercises will be taken from the collection of exam problems, some of which have published solutions.
Date | Topic | Literature | Exercises |
30/8 | Introduction, Relational data model (slides) | KBL 1, 2, 3 | |
6/9 | E-R modeling (slides) | KBL 4 (not UML, i.e. not 4.6 and 4.7.2) | |
13/9 | Normalization (slides) | KBL 6.1-6.8 (except 203-207m), 6.9 (until “MVD”), 6.11, 6.12 | |
20/9 | Modeling case study (case description) | hand-in | |
27/9 | SQL and relational algebra (slides,sql) | KBL 5 | |
4/10 | SQL continued; Indexes (slides,sql) | KBL 9.1-9.4, 9.5 until p. 354 (incl), 9.6.1 | |
11/10 | Query processing (slides); Performance case study (sql) | KBL 10, 12.2 | hand-in |
18/10 | Autumn break | ||
25/10 | SQL in applications, NoSQL (slides, code) | KBL 8.1-8.5, BigTable paper sec. 1-3, MapReduce paper sec. 1-2 | pdf, JDBC .jar, .java |
1/11 | Transactions (slides, sql) | KBL 13.1, (13.2-13.3) | |
8/11 | Guest lecture: Claus Samuelsen, IBM (slides) | Work on hand-in | |
15/11 | XML introduction, XPath (slides, examples) | KBL 17.1-17.2.3, 17.4 | pdf, files |
22/11 | XQuery; XML Schema (slides, examples) | KBL 17.2 (rest), 17.3, XML supplement 15.4.3 | pdf, files |
29/11 | XSLT (slides); Trial exam evaluation (stats) | XML supplement 15.4.2 | work on hand-in |
6/12 | No lecture |