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 |
|
Last offered | Wintersemester 2021 | |
Planned for | Sommersemester 2023 | |
Assigned Study Areas | BIOINFM2510, INFM2510, INFM3110, MDZINFM2510, MEINFM3210 |