News

The last exam for the course in WS2003 will take place on 26.03.2004, 12:00-14:00 in T112.

If you want to take an exam (to improve your grade or because you have not attended any of the previous exams) please write an email to me till the end of February. The following registrations have been received so far for an exam in March:

0155020
0055333
0255027
0256369
0156085

Results of the second exam.

Results of the first exam.

Grading schema:
0-25 5

26-30 4

31-35 3

36-40 2

41-50 1

If you want to see your corrected script please send me an email to arrange an appointment (I will not be available till March 1, but I will submit the grades only after the first week of March).

Time and Location

The lecture takes place on Mondays 12:00-13:30 in the lecture hall HS 12. The language of the course is English.

Registration

The registrations are closed.

The course presents an introduction to the fundamental theory of database management systems with particular emphasis on online databases. The goal of the course is to introduce the basic concepts and problems in relational data modeling, to provide an overview of its application in on-line systems, moreover to give an outlook to other technologies that become increasingly important in the Internet era.

The overview of the course is the following

Course 1: Overview of the course, introduction to database systems.
Course 2: The entity-relationship model: basic definitions, classification of relationships, keys, entity-relationship diagrams, design principles in the ER model.
Course 3: The relational model: basic definitions, the relational algebra, views.
Course 4: Functional dependencies and normal forms (1NF-3NF, BCNF).
Course 5: Indexing and hashing: B-trees, extendible hashing.
Course 6: SQL: data definition, simple queries, views and joins.
Course 7: On-line transaction processing: basic concepts, locking, ACID requirements.
Course 8: On-line analytical processing and search engines (very briefly), overview of the previous courses.
Course 9: XML: basic definitions, universal resource identifiers, namespaces in XML.
Course 10: XML Schema: schema declaration, elements, attributes, types.
Course 11: XPath and XSLT: the data model of XPath for XML documents, location paths, XPath expressions, XSLT, templates, template applications, special features for attributes, conditional processing, sorting.
Course 12: XQuery: processing model, types, expressions (constructors, FLWOR and conditional expressions).

Literature/Lecture Notes

C. J. Date: An Introduction to Database Systems, Addison Wesley, 1995.
G. Brill: Codenotes for XML, Random House, 1998.
World Wide Web Consortium home page.
Also Google can find more than enough freely available documents on the above mentioned topics.

Lecture notes: PDF (compiled on 18. Jan 2004). I plan to extend and update the notes during the semester.

The XML documents for the exercises in the lecture notes. You might also find this schema validator and this XSLT and XQuery processor helpful.

Exam

The second exam takes place on Thursday, February 19, 2004 at 10:15 in HF 9901.

Results of the second exam.

The written exam takes place on the last lecture: Monday, January 26, 2004 at 12:00 in the lecture room HS2.

The exam is 90 minutes long and every kind of written material (scripts, lecture notes, books) are allowed to be used. No computers are allowed (and needed).