Main content

CS 535 — Design and Administration of Databases
(dt. Entwurf und Administration von Datenbanken)

Level, degree of commitment Advanced module, compulsory elective module
Forms of teaching and learning,
workload
Lecture (2 SWS), recitation class (2 SWS),
180 hours (60 h attendance, 120 h private study)
Credit points,
formal requirements
6 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: Oral examination (individual examination)
Language,
Grading
German,
The grading is done with 0 to 15 points according to the examination regulations for the degree program B.Sc. Computer Science.
Duration,
frequency
One semester,
jedes 4. Semester
Person in charge of the module's outline Prof. Dr. Bernhard Seeger

Contents

  • Concepts of data modeling
  • Data modeling languages
  • Conceptual database design
  • Profiling and tuning databases
  • Administration of databases
  • Principles of physical database design
  • Databases in practice

Qualification Goals

Students will

  • Know techniques of conceptual database design and SQL,
  • know basic principles of physical database design for centralized and cloud-based systems and can apply them,
  • can use these systems in an application context,
  • Have methodological knowledge for database tuning.

Prerequisites

None. The competences taught in the following module are recommended: Database Systems.


Applicability

Module imported from B.Sc. Computer Science.

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

  • B.Sc. Data Science
  • B.Sc. Computer Science
  • B.Sc. Business Informatics
  • M.Sc. Data Science
  • M.Sc. Computer Science
  • M.Sc. Business Informatics
  • LAaG Computer Science

When studying M.Sc. Business Informatics, this module can be attended in the study area Compulsory Elective Modules in Computer Science And Mathematics.


Recommended Reading

(not specified)



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 (no corresponding element)
  • 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.