Main content

CS 410 — Database Systems
(dt. Datenbanksysteme)

Level, degree of commitment Advanced module, compulsory elective module
Forms of teaching and learning,
workload
Lecture (4 SWS), recitation class (2 SWS),
270 hours (90 h attendance, 180 h private study)
Credit points,
formal requirements
9 CP
Course requirement(s): Successful completion of at least 50 percent of the points from the weekly exercises as well as at least 2 presentations of the tasks.
Examination type: Written examination
Language,
Grading
German,
The grading is done with 0 to 15 points according to the examination regulations for the degree program B.Sc. Business Informatics.
Duration,
frequency
One semester,
each summer semester
Person in charge of the module's outline Prof. Dr. Bernhard Seeger, Prof. Dr. Thorsten Papenbrock

Contents

  • Methods and tools of data modeling
  • Database models
  • Query languages
  • Application programming
  • Integrity constraints
  • query processing
  • database design
  • transactions
  • Techniques for object-relational mappings

Qualification Goals

Students will

  • Have basic skills in data modeling,
  • Know techniques for translating data models into a database design,
  • have insight into important query calculi,
  • know about the basic functionality of SQL,
  • know the basics of transaction management,
  • are able to deal practically with database management systems,
  • are able to apply scientific working methods when independently identifying, formulating and solving problems,
  • are able to speak freely about scientific content, both in front of an audience and in a discussion.

Prerequisites

None. The competences taught in the following modules are recommended: Object-oriented Programming, Algorithms and Data Structures.


Applicability

Module imported from B.Sc. Business Informatics.

It can be attended at FB12 in study program(s)

  • B.Sc. Data Science
  • B.Sc. Computer Science
  • B.Sc. Business Informatics
  • M.Sc. Mathematics
  • M.Sc. Business Mathematics
  • LAaG Computer Science
  • BA Minor Computer Science

When studying BA Minor Computer Science, this module can be attended in the study area Compulsory Elective Modules in Practical Computer Science.


Recommended Reading

  • Kemper, A. Eickler: "Datenbanksysteme", Oldenbourg, 6. Auflage.
  • Heuer, G. Saake: "Datenbanken: Konzepte und Sprachen", Thomson.
  • G. Saake, Kai-Uwe Sattler: "Datenbanken und Java. JDBC, SQLJ und ODMG", dpunkt Verlag.



Please note:

This page describes a module according to the latest valid module guide in Winter semester 2023/24. Most rules valid for a module are not covered by the examination regulations and can therefore be updated on a semesterly basis. The following versions are available in the online module guide:

  • Winter 2016/17 (no corresponding element)
  • Summer 2018 (no corresponding element)
  • Winter 2018/19 (no corresponding element)
  • Winter 2019/20 (no corresponding element)
  • Winter 2020/21 (no corresponding element)
  • Summer 2021 (no corresponding element)
  • Winter 2021/22 (no corresponding element)
  • Winter 2022/23
  • Winter 2023/24

The module guide contains all modules, independent of the current event offer. Please compare the current course catalogue in Marvin.

The information in this online module guide was created automatically. Legally binding is only the information in the examination regulations (Prüfungsordnung). If you notice any discrepancies or errors, we would be grateful for any advice.