Institute for Informatics
Georg-August-Universität Göttingen

Databases and Information Systems

dbis
Uni Göttingen
Global Links:
Institute for Informatics
Göttingen University
DBIS Links:
People
Teaching
Projects
Publications

Lecture: Databases

  • regularly: PO 2006-2011: 2 SWS + 1 SWS Exercises/Übung; 4 ECTS-Credits; BSc.
  • regularly: PO 2011: 2 SWS + 1 SWS Exercises/Übung; 5 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. For students in BSc Applied Informatics, it is strongly recommended to attend the course in the 3rd semester in case they are interested to attend also the the SQL lab, or advanced courses in the database area already in the BSc studies.

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
  • Syntax of SQL DDL, DML:Updates
  • Overview of database internals: physical storage, optimization, query evaluation
  • Overview of multiuser aspects, transactions, safety
  • Overview of formal database design/normalization

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

The course can optionally be continued with the SQL Lab.