# 184.685 Data Modelling This course is in all assigned curricula part of the STEOP.\$(function(){PrimeFaces.cw("Tooltip","widget_j_id_21",{id:"j_id_21",showEffect:"fade",hideEffect:"fade",target:"isAllSteop"});});This course is in at least 1 assigned curriculum part of the STEOP.\$(function(){PrimeFaces.cw("Tooltip","widget_j_id_23",{id:"j_id_23",showEffect:"fade",hideEffect:"fade",target:"isAnySteop"});}); 2022W 2021W 2020W 2019W 2018W 2017W 2017S 2016W 2016S 2015W 2015S 2014W 2014S 2013W 2013S 2012W 2012S 2011W

2022W, VU, 2.0h, 3.0EC

## Properties

• Semester hours: 2.0
• Credits: 3.0
• Type: VU Lecture and Exercise
• Format: Presence

## Learning outcomes

After successful completion of the course, students are able to

• interpret concepts of ER- and EER- models as well as the relational data model and apply them in order to express given facts;
• abstract relevant concepts from a situation described in natural language, model them in ER- and EER- diagrams and derive relational schemas from such models;
• devise relational schemas (including mechanisms for guaranteeing given integrity constraints on the data) and to implement them in SQL on a relational database management system (RDBMS);
• assess and improve the quality of a relational schema;
• manipulate and query data stored under a relational schema using SQL;
• comprehend and independently formulate database queries in SQL, the Relational Algebra, and the Relational Calculus (this includes being able to formalize requests/queries given as natural language).

## Subject of course

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

## Teaching methods

• This course will be held in presence.
• This course is offered in a blocked format: the recordings will be put online on Mondays and Wednesdays.
• This course will be held both in English and in German: the lectures, the exercise, and the exams will be available in both languages.
• The topics of the course are presented during the lectures
• In the exercise part of the course, the application of the presented methods, concepts, and algorithms are trained.
• The exercise part consists exercise sheets, which are solved by the students as a homework and handed in.
• Practicing the formulation of SQL queries is done in an online tool.
• Exercises are checked by teaching assistants.

## Mode of examination

Immanent

### ECTS Breakdown:

`14h lectures14h preparation for and repetition of lectures26h solving exercise sheets19h exam preparation 2h exam-----------------75h (= 25h * 3ECTS)`

# 1. Test Repetition (Jan 9, 2023) will take place in Informatikhörsaal - ARCH-INF only.

## Course dates

DayTimeDateLocationDescription
Mon11:00 - 13:0003.10.2022 - 14.11.2022 Informatikhörsaal - ARCH-INFLecture recording available online
Wed13:00 - 14:0005.10.2022 - 09.11.2022 Informatikhörsaal - ARCH-INFLecture recording available online
Data Modelling - Single appointments
DayDateTimeLocationDescription
Mon03.10.202211:00 - 13:00 Informatikhörsaal - ARCH-INFLecture recording available online
Wed05.10.202213:00 - 14:00 Informatikhörsaal - ARCH-INFLecture recording available online
Mon10.10.202211:00 - 13:00 Informatikhörsaal - ARCH-INFLecture recording available online
Wed12.10.202213:00 - 14:00 Informatikhörsaal - ARCH-INFLecture recording available online
Mon17.10.202211:00 - 13:00 Informatikhörsaal - ARCH-INFLecture recording available online
Wed19.10.202213:00 - 14:00 Informatikhörsaal - ARCH-INFLecture recording available online
Mon24.10.202211:00 - 13:00 Informatikhörsaal - ARCH-INFLecture recording available online
Mon31.10.202211:00 - 13:00 Informatikhörsaal - ARCH-INFLecture recording available online
Mon07.11.202211:00 - 13:00 Informatikhörsaal - ARCH-INFLecture recording available online
Wed09.11.202213:00 - 14:00 Informatikhörsaal - ARCH-INFLecture recording available online
Mon14.11.202211:00 - 13:00 Informatikhörsaal - ARCH-INFLecture recording available online

## Examination modalities

The final evaluation is based on the performance in the exercise part and a written exam.

## Course registration

Begin End Deregistration end
10.09.2022 09:00 18.10.2022 23:59 18.10.2022 23:59

### Registration modalities

Please notice that it is not allowed to register both for this course and for the course "Data Base Systems". Students enrolled for both courses simultaneously will be removed from both courses.

Registrations from students from Informatics, Business Informatics, and Mathematics will be confirmed. Confirmations of registrations from other studies depend on capacity.

## Curricula

Study CodeObligationSemesterPrecon.Info
033 532 Media Informatics and Visual Computing Mandatory3. Semester
Course requires the completion of the introductory and orientation phase
884 Subject: Informatics und Informatics Management Mandatory5. Semester
Course requires the completion of the introductory and orientation phase

## Literature

No lecture notes are available.

## Previous knowledge

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

German