Database Theory (DA2032)

Professor

Dr. Andreas Kerren, Associate Professor

Time & Place

Compare here (DA2032). In general, the lectures will take place in room D0070a, each Thursday from 10:15 till 12:00.

Teaching Period

I (2008-09-01 till 2008-10-31)

Assessment

Assignments and oral examinations. Oral examinations will take place in week 45, between 5/11 and 7/11.

Prerequisites

DA1031 Programming and Data Structures or corresponding courses

Credits

7.5 ECTS

Topic

Database Theory

This course is intended to give students a solid background in database systems and theory, with a focus on relational database management systems. Topics include general information on database systems, data modeling (E/R model, relational data model), database design theory, data definition and manipulation languages (SQL), and database programming interfaces. In addition to these traditional topics, we cover some advanced topics, such as visual data mining (see above images).

Schedule

Preliminary Schedule:

#	Date	Topic	Slides
1	2008-09-04	Introduction
2	2008-09-11	Entity-Relationship (E/R) Model
3	2008-09-18	Relational Data Model - Part I
4	2008-09-25	Relational Data Model - Part II
5	2008-10-02	Relational Algebra
6	2008-10-09	Structured Query Language (SQL) - Part I
7	2008-10-16	Structured Query Language (SQL) - Part II
8	2008-10-23	Application Programming with SQL
9	2008-10-30	Visual Data Mining and Visual Query Languages

We will also offer additional revision course dates for specific topics if wished. Concrete dates should be discussed with Tobias Gutzmann. If so then they will take place in room D0070a too, on Mondays between 10:15 and 12:00.

Materials

No further materials so far.

Assignments

Assignments consists of theoretical and practical exercices.

Assignments will be supervised by Tobias Gutzmann. You can find general information about our assignments on the first assignment sheet.

Assignments:

Assignment 1 (Deadline: 2008-09-24; Movie Database (ZIP); MySQL Tutorial)
To solve Part 2.2 completely, you can read the MySQL Tutorial.
Assignment 2 (Deadlines: 2008-10-10 (theory) and 2008-10-15 (practice))
Assignment 3 (Deadlines: 2008-10-26 (theory) and for the presentation between 2008-10-29 and 2008-10-31 based on individual meetings with Tobias Gutzmann)

Further Courses

There are further interesting courses in Spring 09 that uses the knowledge of the Database Therory course:

Information Visualization I
Information Visualization II