192.104 Foundations of Information Systems
This course is in all assigned curricula part of the STEOP.
This course is in at least 1 assigned curriculum part of the STEOP.

2022W, VU, 2.0h, 3.0EC
TUWELLectureTube

Properties

  • Semester hours: 2.0
  • Credits: 3.0
  • Type: VU Lecture and Exercise
  • LectureTube course
  • Format: Hybrid

Learning outcomes

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- and class 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.

Subject of course

  • 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
  • Dependency Theory and Relational Design Theory (Dependencies, Normal Forms)

Teaching methods

The course consists of lectures and exercises.   The content of the course is presented in the lectures:

  • Most of content is presented in a classical lecture (recordings of these are provided in TUWEL)
  • To each lecture, a short quiz will be provided in TUWEL
  • Additional information to each topic may be provided in TUWEL (which might be obligatory or voluntary)
  • At the start of each lecture, (at least) 30 minutes are reserved for questions by the students/discussion concerning the content of the course so far, the additional material, the quizzes, the exercises, etc. Presentation of new material does not begin earlier than 30 minutes after the start of the lecture.

In the exercise part of the course, the application of the presented methods, concepts, and algorithms is trained.

  • The exercise part consists of four exercise sheets, which are solved by the students as  a homework and handed in.
  • Practicing the formulation of SQL queries (which is part of at least one exercise sheet) is done in an online tool. Exercises further include the implementation of small programs using a database management system (Postgres or SQLite) as well as solving exercises "with pen and paper".
  • 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 in a format to be decided later.

Mode of examination

Immanent

Additional information

Preliminary Meeting: October 6th, 6.15 pm as announced

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.
The course is given in German!

ECTS Breakdown:

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

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Thu18:00 - 20:0006.10.2022 - 26.01.2023FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Mon18:00 - 20:0012.12.2022EI 10 Fritz Paschke HS - UIW Lecture
Mon18:00 - 20:0009.01.2023EI 10 Fritz Paschke HS - UIW Lecture
Foundations of Information Systems - Single appointments
DayDateTimeLocationDescription
Thu06.10.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu13.10.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu20.10.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu27.10.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu03.11.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu10.11.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu17.11.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu24.11.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu01.12.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Mon12.12.202218:00 - 20:00EI 10 Fritz Paschke HS - UIW Lecture
Thu22.12.202218:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Mon09.01.202318:00 - 20:00EI 10 Fritz Paschke HS - UIW Lecture
Thu19.01.202318:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems
Thu26.01.202318:00 - 20:00FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems

Examination modalities

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 and a computer based TUWEL-Test.

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Fri08:00 - 12:0013.12.2024InfLab Q*bert assessedunknownSQL-Test
Fri08:00 - 12:0013.12.2024InfLab Frogger assessedunknownSQL-Test
Fri08:00 - 12:0013.12.2024InfLab Pong assessedunknownSQL-Test
Mon18:00 - 20:0020.01.2025InfLab Frogger assessedunknownSQL-Test (Nachtermin)
Mon18:00 - 20:0020.01.2025InfLab Q*bert assessedunknownSQL-Test (Nachtermin)
Wed18:00 - 20:0022.01.2025HS 17 Friedrich Hartmann - ARCH assessed06.01.2025 09:00 - 20.01.2025 23:59unknownTest (Haupttermin)
Thu18:00 - 20:0006.03.2025FAV Hörsaal 1 Helmut Veith - INF assessed10.02.2025 09:00 - 04.03.2025 23:59TISSTest (Nachtermin)

Group dates

GroupDayTimeDateLocationDescription
DatenbanktutoriumThu17:00 - 18:0003.11.2022FAV Hörsaal 1 Helmut Veith - INF 192.104 Foundations of Information Systems Datenbanktutorium

Course registration

Begin End Deregistration end
08.09.2022 09:00 14.10.2022 23:59 14.10.2022 23:59

Registration modalities

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".

Precondition

The student must have at least 1 of the course(s) completed listed below:

Group Registration

GroupRegistration FromTo
Datenbanktutorium27.10.2022 09:0003.11.2022 23:59

Curricula

Study CodeObligationSemesterPrecon.Info
045 006 Digital Skills MandatorySTEOP
Course requires the completion of the introductory and orientation phase

Literature

No lecture notes are available.

Previous knowledge

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

Preceding courses

Language

German