| Professor |
Dr. Andreas Kerren, Associate Professor
|
| Time & Place |
Compare here (DA2032)
|
| Teaching Period |
I (2007-09-06 till 2007-10-25)
|
| Assessment |
Assignments and oral examinations. Oral examinations will take place in week 45, between 5/11 and 8/11.
|
| Prerequisites |
DAA700 (Computer Science, general course) 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
|
| 1 |
2007-09-06 |
Introduction
|
| 2 |
2007-09-17 |
Entity-Relationship (E/R) Model
|
| 3 |
2007-09-20 |
Relational Data Model - Part I
|
| 4 |
2007-09-27 |
Relational Data Model - Part II
|
| 5 |
2007-10-04 |
Relational Algebra
|
| 6 |
2007-10-11 |
Structured Query Language (SQL) - Part I
|
| 7 |
2007-10-18 |
Structured Query Language (SQL) - Part II
|
| 8 |
2007-10-22 |
Application Programming with SQL
|
| 9 |
2007-10-25 |
Visual Data Mining and Visual Query Languages
|
| 10 |
2007-11-01 |
Optional Revision Course: FD's and MVD's
|
|
Slides & Materials |
Slides (PDFs) can be downloaded here:
|
| 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: 2007-09-26; Movie Database (ZIP); MySQL Tutorial)
To solve Part 2.2 completely, you can read the MySQL Tutorial.
There is also a small typo: Reference "2.16" in Part 2.1 must be "2.4.16"!
- Assignment 2 (Deadlines: 2007-10-10 (theory) and 2007-10-21 (practice))
- Assignment 3 (Deadlines: 2007-10-26 (theory) and for the presentation
between 2007-10-29 and 2007-11-01 based on individual meetings with Tobias Gutzmann; MySQL-C# API Instructions)
|
| Further Courses |
There is a further interesting course in Fall 07 that extends/uses the knowledge of the Database Therory course:
|
