Module Number

INF3131
Module Title

Introduction to Relational Database Systems (DB1)
Type of Module

Elective Compulsory
ECTS 9
Work load
- Contact time
- Self study
Workload:
270 h
Class time:
90 h / 6 SWS
Self study:
180 h
Duration 1 Semester
Frequency In the winter semester
Language of instruction German
Type of Exam

Exam + exercise grade

Lecture type(s) Lecture, Tutorial
Content

Database usage; database models and languages (types, declarativity, data independence, persistence); relational data model and SQL; normal forms, functional dependencies; entity-relationship model; relational algebra; recursive algebra; Recursive queries; Practical use (PostgreSQL)

Objectives

This module provides a broad base of database system fundamentals (primarily: relational database systems). Students will be able to query, modify database systems. Students learn the basics of relational data models and their implementation in the form of SQL-based database systems. Students will be able to design and evaluate database schemas and query, modify database instances. Existing database systems can be assessed with regard to their quality and efficiency.

Allocation of credits / grading
Type of Class
Status
SWS
Credits
Type of Exam
Exam duration
Evaluation
Calculation
of Module (%)
Prerequisite for participation There are no specific prerequisites.
Lecturer / Other Grust
Literature

Kemper/Eickler: Datenbanksysteme: Eine Einführung
Heuer/Saake: Datenbanksysteme – Konzepte und Sprachen
Relationale Datenbanksysteme (Software und Manuals), u.a. PostgreSQL

Last offered Wintersemester 2021
Planned for Sommersemester 2023
Assigned Study Areas BIOINFM2510, INFM2510, INFM3110, MDZINFM2510, MEINFM3210