Database Theory (1DV013)

Professor

Prof. Dr. Andreas Kerren

Time & Place

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

Teaching Period

I (2010-08-30 till 2010-11-07)

Assessment

Assignments and oral examinations. Oral examinations will take place in week 45.

Prerequisites

At least one year of university studies (equal to 60 higher education credits) including a basic course in data structures as well as good programming experiences.

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	2010-08-30	Introduction
2	2010-09-06	Entity-Relationship (E/R) Model
3	2010-09-13	Relational Data Model - Part I
4	2010-09-20	Relational Data Model - Part II
5	2010-09-27	Relational Algebra
6	2010-10-04	Structured Query Language (SQL) - Part I
7	2010-10-11	Structured Query Language (SQL) - Part II
8	2010-10-18	Application Programming with SQL
9	2010-10-21	Visual Data Mining and Visual Query Languages
10	2010-10-25	Optional Revision Course [given by Antonina Khairova]

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 here.

Assignments:

The solutions of your assignments have to be uploaded via Blackboard!

Assignment 1 (Deadline: 2010-09-20; Movie Database (ZIP); MySQL Tutorial)
Assignment 2 (Deadline for the theoretical part: 2010-10-04; extended deadline for the practical part: 2010-10-13)
Assignment 3 (Deadline: 2010-10-13 (theory))
Assignment 4 (Deadline: 2010-10-28 and for the presentation between 2010-10-25 (in case you are quick) and 2010-10-30 based on individual meetings with Antonina Khairova)

Further Courses

There are further interesting courses in Fall 10 and Spring 11 that use the knowledge of the Database Therory course: