After successful completion of the course, students are able to

• classify basic concepts of and techniques for information systems;
• explain the concept of data independence, describe different data models and asses the advantages and disadvantages of these data models for different applications;
• interpret concepts UML2 object-, class-, activity- and state machine diagrams 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 the aforementioned diagrams and derive relational schemas from them;
• 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 and the Relational Algebra (this includes being able to formalize requests/queries given as natural language);
• describe basic relationsships and constraints using formal dependencies.

• Introduction, Basics, Overview
• Data Models, Database Systems, Data Independence
• The Relational Model (Basics, Design)
• Relational Query Languages
• Relational Algebra
• SQL
• Conceptual Modelling
• UML2
• Object Diagram
• Class Diagram
• Activity Diagram
• State Machine Diagram
• Dependency Theory and Relational Design Theory (Dependencies, Normal Forms, Knowledge Graphs)

• The topics of the course are presented during the lectures
  It is planned to hold the lectures live as Zoom meetings (live audience is explicitely welcome) which are recorded. The recorded lectures are made available.
• To each lecture, a short quiz will be provided in TUWEL
• In the exercise part of the course, the application of the presented methods, concepts, and algorithms is 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 (which is part of the first exercise sheet) is done in an online tool.
• The lecturer and teaching assistants offer online consultation hours.
• The exercises are checked by the teaching assistants, graded by the lecturer and returned to the students (enhanced with some feedback)
• The correct solutions are presented by the lecturer and discussed with the audience in extra online lectures.

Preliminary Meeting: October 1st, 7.15 pm as Zoom meeting (link in TUWEL)

Contact: In case of any questions, please contact gdi@list.tuwien.ac.at

Material:

All material (slides, lecture recordings, exercise sheets) as well as additional organisational information are provided in the accompanying TUWEL-course.

ECTS Breakdown:

20h   lectures
12h   preparation for and repetition of lectures
16h   solving exercise sheets
15h   exam preparations
10h   final project
 2h   exams
------------------
75h (= 25h * 3ECTS)

The final evaluation is based on the performance at the exercises (evaluation is based on the submission), the participation during the course, a the computer-based SQL-test, a computer based TUWEL-Test and a small final "project".

This course is exclusively for students of the program 045 006 "Digital Skills". Registrations with a different code unfortunately will be rejected.

Please also note that you have to successfully finished both, the STEOP in your main program and the course  "Foundatoins fo programming and algorithms".

Basic Python programming skills as taught in the lecture "Grundlagen der Programmierung und Algorithmis" are advantageous.