184.686 Data Base 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.
This course is in at least 1 assigned curriculum part of the STEOP.

2023S, VU, 4.0h, 6.0EC
TUWELLectureTube

Properties

  • Semester hours: 4.0
  • Credits: 6.0
  • Type: VU Lecture and Exercise
  • LectureTube course
  • 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);
  • develop and apply procedures in a procedural database programming language;
  • evaluate properties of parallel transactions and to identify problems caused by parallel processing of transactions;
  •  systematically apply different isolation levels;
  • execute and understand the presented methods and concepts for recovery and concurrency control.

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)
  • Database programming (with pgSQL)
  • SQL-extensions
  • Transactions
  • error handling / recovery
  • concurrency control

Teaching methods

  • This course will be held in presence.
  • This course is offered in a blocked format: The lecture part (not the exercises) will end about 4 weeks before the lecturing period ends.
  • 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. (The english lecture is presented through recordings, not live presentations)
  • In the exercise part of the course, the application of the presented methods, concepts, and algorithms are trained.
  • The exercise part consists of exercise sheets, which are solved by the students as homework and handed in.
  • Practicing the formulation of SQL queries is done in an online tool.
  • Ahead of the deadlines questions can be asked in the forum, teaching assistants will answer them there.
  • Exercises are discussed and checked by teaching assistants.

 

Mode of examination

Immanent

Additional information

ECTS Breakdown:

 30h   lectures
30h preparation for and repetition of lectures
52h solving exercise sheets
0,5h exercise interviews
34h exam preparation
 3,5h exam
------------------
150h (= 25h * 6ECTS)

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Mon14:00 - 16:0006.03.2023 - 26.06.2023GM 1 Audi. Max.- ARCH-INF Lecture
Tue14:00 - 16:0007.03.2023 - 06.06.2023GM 1 Audi. Max.- ARCH-INF Lecture
Thu15:00 - 17:0009.03.2023 - 29.06.2023Seminarraum FAV EG C (Seminarraum Gödel) Q&A English Track
Thu16:00 - 18:0016.03.2023Seminarraum FAV 01 A (Seminarraum 183/2) 184.686 Database Systems
Thu13:00 - 15:0001.06.2023GM 1 Audi. Max.- ARCH-INF Repetitorium (Test 1)
Data Base Systems - Single appointments
DayDateTimeLocationDescription
Mon06.03.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Tue07.03.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Thu09.03.202315:00 - 17:00Seminarraum FAV EG C (Seminarraum Gödel) Q&A English Track
Mon13.03.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Tue14.03.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Thu16.03.202316:00 - 18:00Seminarraum FAV 01 A (Seminarraum 183/2) 184.686 Database Systems
Mon20.03.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Tue21.03.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Thu23.03.202315:00 - 17:00Seminarraum FAV EG C (Seminarraum Gödel) Q&A English Track
Mon27.03.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Tue28.03.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Thu30.03.202315:00 - 17:00Seminarraum FAV EG C (Seminarraum Gödel) Q&A English Track
Mon17.04.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Tue18.04.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Thu20.04.202315:00 - 17:00Seminarraum FAV EG C (Seminarraum Gödel) Q&A English Track
Mon24.04.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Tue25.04.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Thu27.04.202315:00 - 17:00Seminarraum FAV EG C (Seminarraum Gödel) Q&A English Track
Tue02.05.202314:00 - 16:00GM 1 Audi. Max.- ARCH-INF Lecture
Thu04.05.202315:00 - 17:00Seminarraum FAV EG C (Seminarraum Gödel) Q&A English Track

Examination modalities

The final evaluation is based on the performance in the exercise part and two written exams.

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Fri17:00 - 19:0024.05.2024 FH 8 Nöbauer HS - MATHwritten08.05.2024 10:00 - 15.05.2024 23:00TISSEnglish Exam
Fri17:00 - 19:0024.05.2024Informatikhörsaal - ARCH-INF written29.04.2024 13:00 - 15.05.2024 23:00TISSPrüfung
Fri17:00 - 19:0024.05.2024FH 8 Nöbauer HS - MATH written29.04.2024 13:00 - 15.05.2024 23:00TISSPrüfung
Fri17:00 - 19:0024.05.2024FH Hörsaal 1 - MWB written29.04.2024 13:00 - 15.05.2024 23:00TISSPrüfung
Fri17:00 - 19:0024.05.2024GM 2 Radinger Hörsaal - TCH written29.04.2024 13:00 - 15.05.2024 23:00TISSPrüfung
Fri17:00 - 19:0024.05.2024HS 17 Friedrich Hartmann - ARCH written29.04.2024 13:00 - 15.05.2024 23:00TISSPrüfung
Fri17:00 - 19:0024.05.2024GM 1 Audi. Max.- ARCH-INF written29.04.2024 13:00 - 15.05.2024 23:00TISSPrüfung
Fri17:00 - 19:0024.05.2024EI 7 Hörsaal - ETIT written29.04.2024 13:00 - 15.05.2024 23:00TISSPrüfung
Fri17:00 - 19:0024.05.2024GM 5 Praktikum HS- TCH written29.04.2024 13:00 - 15.05.2024 23:00TISSPrüfung
Wed18:00 - 20:0026.06.2024FH Hörsaal 1 - MWB writtenno application-Prüfung
Wed18:00 - 20:0026.06.2024GM 1 Audi. Max.- ARCH-INF writtenno application-Prüfung
Wed18:00 - 20:0026.06.2024GM 5 Praktikum HS- TCH writtenno application-Prüfung
Wed18:00 - 20:0026.06.2024FH 8 Nöbauer HS - MATH writtenno application-Prüfung
Wed18:00 - 20:0026.06.2024GM 2 Radinger Hörsaal - TCH writtenno application-Prüfung
Wed18:00 - 20:0026.06.2024EI 7 Hörsaal - ETIT writtenno application-Prüfung
Wed18:00 - 20:0026.06.2024HS 17 Friedrich Hartmann - ARCH writtenno application-Prüfung
Wed18:00 - 20:0026.06.2024Informatikhörsaal - ARCH-INF writtenno application-Prüfung
Wed18:00 - 20:0026.06.2024FH Hörsaal 5 - TPH writtenno application-Prüfung
Thu17:00 - 19:0026.09.2024GM 1 Audi. Max.- ARCH-INF written09.09.2024 10:00 - 25.09.2024 23:59TISSPrüfung Ersatztermin
Wed18:00 - 20:0028.05.2025HS 17 Friedrich Hartmann - ARCH writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025EI 7 Hörsaal - ETIT writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025Informatikhörsaal - ARCH-INF writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025EI 3 Sahulka HS - UIW writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025GM 1 Audi. Max.- ARCH-INF writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025GM 5 Praktikum HS- TCH writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025GM 2 Radinger Hörsaal - TCH writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025FH Hörsaal 1 - MWB writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025HS 18 Czuber - MB writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025FH Hörsaal 5 - TPH writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025FH Hörsaal 6 - TPH writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Wed18:00 - 20:0028.05.2025EI 9 Hlawka HS - ETIT writtenno application-1. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025FH Hörsaal 1 - MWB writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025Informatikhörsaal - ARCH-INF writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025GM 1 Audi. Max.- ARCH-INF writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025FH Hörsaal 6 - TPH writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025EI 7 Hörsaal - ETIT writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025GM 2 Radinger Hörsaal - TCH writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025GM 5 Praktikum HS- TCH writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025HS 17 Friedrich Hartmann - ARCH writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025HS 18 Czuber - MB writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025FH Hörsaal 5 - TPH writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025EI 9 Hlawka HS - ETIT writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Mon18:00 - 20:0030.06.2025EI 3 Sahulka HS - UIW writtenno application-2. Test (Hörsaalreservierung für nächstes Semester)
Thu - 25.09.2025written08.09.2025 10:00 - 24.09.2025 23:59TISSPrüfung Ersatztermin (Hörsaalreservierung für nächstes Semester)

Group dates

GroupDayTimeDateLocationDescription
Besprechung Übungsblätter (LVA Leitung)Fri15:00 - 17:0012.05.2023Seminarraum FAV 01 C (Seminarraum 188/2) 184.686 Data Base Systems Besprechung Übungsblätter (LVA Leitung)
Besprechung Übungsblätter (LVA Leitung)Tue16:00 - 18:0016.05.2023Seminarraum FAV 01 C (Seminarraum 188/2) 184.686 Data Base Systems Besprechung Übungsblätter (LVA Leitung)
EinsichtnahmeMon15:00 - 16:0003.07.2023Seminarraum FAV 01 C (Seminarraum 188/2) 184.686 Data Base Systems Einsichtnahme
Fragestunden (Tutor:innen)Tue16:00 - 18:0018.04.2023Seminarraum FAV 01 C (Seminarraum 188/2) 184.686 Data Base Systems Fragestunden (Tutor:innen)
Fragestunden (Tutor:innen)Mon16:00 - 18:0024.04.2023Seminarraum FAV 01 C (Seminarraum 188/2) 184.686 Data Base Systems Fragestunden (Tutor:innen)
Fragestunden (Tutor:innen)Thu13:00 - 15:0004.05.2023Seminarraum FAV EG B (Seminarraum von Neumann) 184.686 Data Base Systems Fragestunden (Tutor:innen)
Fragestunden (Tutor:innen)Mon16:00 - 18:0022.05.2023Seminarraum FAV 01 C (Seminarraum 188/2) 184.686 Data Base Systems Fragestunden (Tutor:innen)
Fragestunden (Tutor:innen)Mon16:00 - 18:0005.06.2023Seminarraum FAV 01 C (Seminarraum 188/2) 184.686 Data Base Systems Fragestunden (Tutor:innen)

Course registration

Begin End Deregistration end
13.02.2023 10:00 11.03.2023 23:59 11.03.2023 23:59

Registration modalities

All registrations from students from Informatics, Business Informatics, Mathematics, and Data Science Master will be confirmed. Confirmations of registrations from other studies depend on capacity.

Group Registration

GroupRegistration FromTo
Besprechung Übungsblätter (LVA Leitung)05.05.2023 09:0006.05.2023 09:00
Einsichtnahme29.06.2023 09:0003.07.2023 14:00
Fragestunden (Tutor:innen)12.04.2023 09:0012.04.2023 09:01

Curricula

Study CodeObligationSemesterPrecon.Info
033 201 Technical Mathematics Not specified
033 526 Business Informatics Mandatory3. Semester
033 532 Media Informatics and Visual Computing Mandatory2. Semestertrue
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")
033 533 Medical Informatics Mandatory2. Semestertrue
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")
033 534 Software & Information Engineering Mandatory2. Semestertrue
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")
033 535 Computer Engineering Mandatory elective3. Semester
066 646 Computational Science and Engineering Not specified
860 GW Optional Courses - Technical Mathematics Not specifiedtrue
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")

Literature

No lecture notes are available.

Previous knowledge

There are no formal prerequisites for this course. However, it is strongly recommended to take the courses EP1 and GDS before this course.

Miscellaneous

Language

German