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

2017W, VU, 2.0h, 3.0EC

Properties

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

Aim of course

Note: This course is intended only for students who have already successfully taken the course "184.685 Data Modelling" and for whom this course is required as part of the transitional regulations for the new degree course schemes starting in 2017. (This course is a compensation for all those students who must take the course "Database Systems" for the fact that the topics from the course "Data Modelling" are now part of the course "Database Systems".)

Please send emails concerning this course exclusively to dbs@dbai.tuwien.ac.at

Goals:

The course provides a deeper understanding of basic concepts of relational database systems. Students learn to maintain data integrity in such systems, and to understand the foundations of transactions, recovery, and the synchronisation of multiple users, and to apply these concepts in relational database management systems. In addition, students learn to understand, formalize, plan, and apply advanced features of database languages.

Subject of course

Focuses:

  • Database programming (with pgSQL)
  • SQL-extensions
  • Transactions
  • error handling / recovery
  • multi-user synchronization

Additional information

Note:

As already pointed out earlier, this course is only for student who already passed the course "Data Modelling" and as part of the transitional regulations for the degree course scheme starting in 2017 are not required to take the full course "Database Systems", which now includes all of the content of "Data Modelling".

ECTS Breakdown:

15h lectures (1h preliminary meeting, 14h lectures)
14h preparation for and repetition of lectures
26h solving exercise sheets
19h exam preparation
 1h exam
-----------------
75h (= 25h * 3ECTS)

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Mon11:00 - 13:0030.10.2017 - 27.11.2017Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed11:00 - 13:0001.11.2017 - 29.11.2017Informatikhörsaal Lecture (parallel to VU Database Systems)
Data Modelling - Single appointments
DayDateTimeLocationDescription
Mon30.10.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed01.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Mon06.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed08.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Mon13.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed15.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Mon20.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed22.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Mon27.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed29.11.201711:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)

Examination modalities

Two exercise sheets and a written exam

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Wed15:00 - 17:0026.08.2020EI 7 Hörsaal - ETIT assessed01.07.2020 09:00 - 23.08.2020 23:59TISS3. Nebentermin (Prüfung 2)
Thu15:00 - 17:0017.09.2020EI 7 Hörsaal - ETIT assessed01.09.2020 09:00 - 14.09.2020 23:59TISS4. Nebentermin (Prüfung 2)
Fri18:00 - 20:0022.01.2021GM 1 Audi. Max.- ARCH-INF assessed03.01.2021 09:00 - 20.01.2021 09:00TISSPrüfung 1
Tue17:00 - 19:0009.03.2021EI 10 Fritz Paschke HS - ETIT assessed11.02.2021 09:00 - 08.03.2021 09:00TISS1. Nebentermin (Prüfung 1)
Wed - 05.05.2021assessed21.04.2021 09:00 - 03.05.2021 23:59TISS2. Nebentermin (Prüfung 1)
Fri15:00 - 17:0018.06.2021EI 7 Hörsaal - ETIT assessed28.05.2021 08:00 - 15.06.2021 23:59TISS2. Nebentermin (Prüfung 2) (Paralleltermin)

Course registration

Begin End Deregistration end
10.09.2017 09:00 17.10.2017 23:55 17.10.2017 23:55

Registration modalities:

Bitte beachten Sie, dass eine gleichzeitige Anmeldung zu den LVAs Datenbanksysteme oder Datenmodellierung nicht erlaubt sind. Bei Anmeldung zu mehr als einer dieser drei LVAs mit Ende der Anmeldefrist erfolgt eine Abmeldung von allen drei LVAs.

Anmeldungen aller Studierenden aus Informatik und Wirtschaftsinformatik werden bestätigt. Studierende anderer Studien je nach vorhandener Kapazität.

Curricula

Literature

No lecture notes are available.

Previous knowledge

The topics presented as part of the course "Data Modelling" are assumed to be known by the student. They are not recalled or repeated as part of the lectures. If needed, the corresponding lectures of the course "data modelling", which take place before the lecture of the present course, should be visited.

Preceding courses

Miscellaneous

Language

German