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.

Focuses:

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

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)

Two exercise sheets and a written exam

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.

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.