184.685 Data Modelling
This course is in all assigned curricula part of the STEOP.
This course is in at least 1 assigned curriculum part of the STEOP.

2019W, VU, 2.0h, 3.0EC
TUWEL

Properties

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

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

  • 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 of two 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.
  • Ahead of the deadlines, teaching assistants offer consultation hours.
  • The exercises are checked by the teaching assistants and returned to the students (enhanced with some feedback)
  • The correct solutions are presented by the lecturers and discussed with the audience in extra lectures.

Mode of examination

Immanent

Additional information

ECTS Breakdown:

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

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Wed11:00 - 13:0002.10.2019 - 30.10.2019Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Mon11:00 - 13:0007.10.2019 - 28.10.2019Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Data Modelling - Single appointments
DayDateTimeLocationDescription
Wed02.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Mon07.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Wed09.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Mon14.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Wed16.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Mon21.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Wed23.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Mon28.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)
Wed30.10.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU 184.686 Database Systems)

Examination modalities

The final evaluation is based on the performance at the exercises (evaluation is based on the submission), at the computer-based SQL-test, and a written exam.

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Fri19:00 - 21:0004.12.2020GM 1 Audi. Max.- ARCH-INF assessed13.11.2020 09:00 - 02.12.2020 23:59TISSPrüfung 1
Fri19:00 - 21:0015.01.2021GM 1 Audi. Max.- ARCH-INF assessed01.01.2021 09:00 - 13.01.2021 23:59TISSPrüfung 1 - Wiederholung

Course registration

Begin End Deregistration end
07.09.2019 09:00 15.10.2019 23:59 15.10.2019 23:59

Registration modalities:

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.

Curricula

Study CodeSemesterPrecon.Info
033 532 Media Informatics and Visual Computing 3. SemesterSTEOP
Course requires the completion of the introductory and orientation phase
884 Subject: Informatics und Informatics Management 5. SemesterSTEOP
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.

Miscellaneous

Language

German