[News] [Schedule] [Course description] [Links] [Hand-ins] [Intranet]
Hand-in 4 (Deadline November 12) and the accompanying file actors.xml (compressed) are available. Jar files for XML processing: jaxen.jar, jdom.jar, saxon.jar (place in Java classpath), and ValidateXMLSchema.java.
To download the XML file for the XML exercises, use your browser's "save as" feature. Otherwise it will display the result of running the stylesheet rather than downloading it.
Teaching will take place in room 3A14 from 9 to 12 and in room 3A52 from 13 to 15.
This is a tentative plan. Changes to contents and/or reading material may occur. More detailed reading diretions will be given during the semester. Some chapters will be partly included.
| Date | Subject | Literature | Exercises | Hand-in |
| Aug. 25 | Introduction - slides, scripts with examples used in the lecture. | KBL 1, 2 | Ex1 | - |
| Sep. 1 | Relational data model - slides | KBL 3 | Ex2 | - |
| Sep. 8 | E-R modelling - slides | KBL 4 (not UML, i.e. not 4.6 and 4.7.2) | Ex3 | Hand-in 1 (Sept. 10) |
| Sep. 15 | SQL and relational algebra - slides | KBL 5 | Ex4 | - |
| Sep. 22 | SQL and relational algebra - slides | KBL 5 | Ex5 | - |
| Sep. 29 | SQL in applications, Indexes - slides | KBL 8.1-8.5, 9.1-9.4, 9.5 until p. 354 (incl), 9.6.1 | Ex6, LoadActors.java, data, JDBC JAR | Hand-in 2 (Oct. 1) |
| Oct. 6 | Normalization - slides 1, slides 2 | KBL 6.1-6.8 (except 203-207m), 6.9 (until "MVD"), 6.11, 6.12 | Ex7 | - |
| Oct. 13 | No lecture (fall break) | - | - | |
| Oct. 20 | XML, XPath, and XSLT - slides | KBL 15.1, 15.2, 15.4.1-2 | Ex8, linkedrecipes.xml, selectstuff.xsl | Hand-in 3, data set |
| Oct. 27 | XQuery and XML Schema - slides | KBL 15.3+ 15.4.3-4 | Ex9, students.xml, students.xsd | - |
| Nov. 3 | Query processing - slides | KBL 10, 12.2 | Ex10 | - |
| Nov. 10 | Transactions - slides | KBL appendix A.1 | Ex11 | Hand-in 4 |
| Nov. 17 | Summary, Exam preparation - slides | - | Trial exams | - |
| Jan. 5 | Written exam (9.00-13.00) |
Literature:
Hand-ins will be done in groups of 3-4 students. They have to be approved to enter the exam.
Hand-ins on the following dates:
|
Anna Pagh (lectures, course responsible) E-mail: annao@itu.dk |
Rasmus Pagh (lectures) Office: 3C 07 E-mail: pagh@itu.dk |
Andrea Campagna (exercises and hand-ins) E-mail: acam |