The course teaches the students the basics of

• the relational model
• the modeling of information using the relational model
• the use of relationales database management systems.

Students learn to abstract and model relevant facts from descriptions provided in natural language and to translate these models into relational schemas. They further learn to implement these schemas in relational database management systems, to manipulate data stored under such schemas, and to query the resulting databases. Students also learn to apply tools that allow them to measure the quality of relational schemas.

• Semantic Data Modelling; EER-diagrams
• The Relational Model (Basics, Translation using EER-diagrams)
• Relational Query Languages (Relational Algebra, Tuple/Domain Relational Calculus, SQL)
• Design Theory for Relational Databases (Functional Dependencies, Normalforms)

ECTS Breakdown:

14h lectures
14h preparation for and repetition of lectures
26h solving exercise sheets
19h exam preparation
 2h exam
-----------------
75h (= 25h * 3ECTS)

The two exercise sheets, the SQL exam and the final written examination are part of the evaluation.

Bitte beachten Sie, dass eine gleichzeitige Anmeldung zu dieser LVA sowie den LVAs "Datenbanksysteme" und "Datenmodellierung 2" nicht erlaubt ist. Studierende, welche am Ende des Anmeldezeitraumes zu mehr als einer dieser drei LVAs angemeldet sind werden von allen 3 LVAs abgemeldet.

Alle Anmeldungen von Studierenden aus Informatik oder Wirtschaftsinformatik werden bestätigt. Anmeldungen von Studierenden aus anderen Studien je nach vorhandener Kapazität.

There are no formal prerequisites for this course. However, it is strongly recommended to take the course "Formal Modelling" prior to this course.