Lecture: Databases

• regularly: 2 SWS + 1 SWS Exercises/Übung; 4 ECTS-Credits; BSc.
• WS05/06, WS06/07, and WS07/08: 3 SWS + 1 SWS Exercises/Übung; 6 ECTS-Credits (Export to TU Clausthal)

The course is usually taught in the winter term.

Contents:

The module is an introductory course to (relational) databases:

• conceptual modeling (ER model)
• logical modeling: relational model
• relational algebra (theoretical foundations for query languages)
• SQL queries
• database internals: physical storage, optimization, query evaluation
• for 6 ECTS: multiuser aspects, transactions, safety

The course uses the Mondial database for illustrations and practical experiments.

Prerequisites: "Informatik I/II"; for students in Informatics additionally "Discrete Mathematics".

The course can optionally be continued with the SQL Lab.

• WS 2002/03
• WS 2003/04
• WS 2004/05
• WS 2005/06
• WS 2006/07
• WS 2007/08
• WS 2008/09
• WS 2009/10