Database Theory (1DV013)

Professor

Prof. Dr. Andreas Kerren

Time & Place

Compare here (1DV013).

Teaching Period

I (2012-09-03 till 2012-11-02)

Assessment

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

Prerequisites

60 higher education credits in Computer Science including a course in Programming and 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	2012-09-06	Introduction
2	2012-09-17	Entity-Relationship (E/R) Model
3	2012-09-20	Relational Data Model - Part I
4	2012-09-27	Relational Data Model - Part II
5	2012-10-04	Relational Algebra
6	2012-10-08	Structured Query Language (SQL) - Part I
7	2012-10-11	Structured Query Language (SQL) - Part II
8	2012-10-25	Application Programming with SQL
9	2012-10-31	Visual Data Mining and Visual Query Languages
10	2012-11-02	Optional Revision Lecture [given by Antonina Danylenko]	-

Materials

No further materials so far.

Assignments

Assignments consists of theoretical and practical exercices.

Assignments will be supervised by Antonina Danylenko. You can find general information about our assignments here.

Assignments:

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

Assignment 1 (Deadline: 2012-09-28; Movie Database (ZIP))
Assignment 2 (Deadline for the theoretical part: 2012-10-10; extended deadline for the practical part: 2012-10-22)
Assignment 3 (Deadline: 2012-10-22 (theory))
Assignment 4 (Deadline: 2012-11-21)

Further Courses

There are further interesting courses (master's level!) in Fall 12 and Spring 13 that use the knowledge of the Database Therory course: