Database Systems

11B0077

Bachelor

German

5.0

winter and summer term

1 semester

Databases are the standard method for persisting, retrieving, and maintaining mass data and are therefore indispensable for a very large proportion of applications in the field of computer science. This module teaches the basics of data management. This includes design, modeling, and data management based on modern database management systems. An insight into current database technologies and advanced concepts round off the learning experience.

1. terms, concepts and architectures

2. database management systems and their foundation

3. data models (relational and NOSQL)

3. data schemas

Schema-on-read, schema-on-write
Conceptual and logical data modeling (e.g. ER modeling, table design)

4. transfer of the modeling to a concrete data model (e.g. from EER to relational)

5. normalization, normal forms, redundancy, efficiency aspects

6. introduction to a query language (e.g. SQL) together with programming language extensions

7. use of databases from programming languages

9. introduction to advanced database technologies

The total workload for the module is 150 hours (see also "ECTS credit points and grading").

• Written examination or
• Homework / Assignment

• Field work / Experimental work or
• Regular participation

The selection of graded and ungraded examination types from the specified options is the responsibility of the respective teacher. In doing so, the teacher must adhere to the applicable study regulations.

Written exam K2 - see study regulations

Term paper - approx 15 pages, rpresentation approx. 10 minutes

Students taking the module should have practical programming knowledge of object-oriented programming analogous to the concepts taught in the course Programming 1 (I). Students who would like to refresh their programming skills in preparation for the module are recommended to participate in a cloud-based MOOC, for example. 

Students who have successfully studied this subject are familiar with current database technologies and their areas of application.

Students have in-depth knowledge of modelling, normalization, transactions and a database query language.

Students can model, introduce and query databases. They adhere to established quality assurance development processes. They are able to critically reflect on their results. Students are practiced in dealing with selected database technologies and can assess their applicability and practical relevance in relation to the situation and domain.

Students are able to use modern and established database technologies as part of complex information technology projects. They can independently learn new database technologies and concepts and incorporate them into practical projects.

Students can present the results they have developed to an expert audience in formal presentations. They are capable of engaging in critical professional discussions with colleagues, users, database experts, and software developers.

• Tapken, Heiko

• Tapken, Heiko
• Kleuker, Stephan