Database Theory (DA2032)

Professor

Prof. Dr. Andreas Kerren

Time & Place

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

Teaching Period

I (2009-08-31 till 2009-10-30)

Assessment

Assignments and oral examinations. Oral examinations will take place in week 46, between 10/11 and 13/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	2009-08-31	Introduction
2	2009-09-07	Entity-Relationship (E/R) Model
3	2009-09-14	Relational Data Model - Part I
4	2009-09-17	Relational Data Model - Part II
5	2009-09-21	Relational Algebra
6	2009-09-28	Structured Query Language (SQL) - Part I
7	2009-10-01	Structured Query Language (SQL) - Part II
8	2009-10-05	Application Programming with SQL
9	2009-10-26	Visual Data Mining and Visual Query Languages

Materials

No further materials so far.

Assignments

Assignments consists of theoretical and practical exercices.

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

Assignments:

Assignment 1 (Deadline: 2008-09-21; Movie Database (ZIP); MySQL Tutorial)
To solve Part 2.2 completely, you can read the MySQL Tutorial.
Assignment 2 (Deadline: 2009-10-05; Extended to 2009-10-12)
Assignment 3 (Deadlines: 2009-10-26 (theory) and for the presentation between 2009-11-02 and 2009-11-04 based on individual meetings with Antonina Khairova)

Further Courses

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

Information Visualization
Applied Information Visualization