Due to the current situation of the shutdown of presence lectures at the University of Vienna till end of semester, we have to do some additional slight modifications of our planned schedule of the DBS lectures. 

First of all, as stated already, we are convinced that there will not be disadvantages for you, the students. 

From today’s point of view, there are no modifications to the time schedule. However, due to the situation that no presence lectures are allowed, we will switch the lectures to reading mode. 

All lectures are available and downloadable from the CEWebS site. According to our original plan (https://cewebs.cs.univie.ac.at/DBS/ss20/index.php?t=dates) for each lecture a start date is given, when the lectures have to be processed (read and comprehended) by students, e.g. lecture “Relational Model” starts on 21.04.2020. Until the next lecture the students are advised, if necessary, to use the forum to pose questions on unclear or ambiguous topics. We will answer these questions in timely fashion. 

This proposed process aims to cluster questions and answers related to the planned sequence of lecture topics. Of course, questions on anything can be raised anytime. 

There are no modifications to the deadlines and requirements of the project’s milestones. You can present worksheets and milestones in the online classes. Please, inform Benedikt Pittl immediately, if you cannot attend any online class (bad internet connection…). 

 

We are sorry that we had to do these modifications, but we are forced by the situation and have to follow the guidelines of the University. 

 

We wish you all the best, and stay safe and healthy. 

 

 

 

 

 

 

«Information in courses directory» 

Practical lessons according to registration 

 

Kickoff class (presence mandatory) in the first theoretical lecture on 03.03. 13:15 

Note that the kickoff class will take place in Seminarraum 4 and Seminarraum 5 

Mandatory presence in the first practical lesson according to registered group. 

 

Theoretical lectures 

The course is an optional part covering 6 ECTS of the core-programme CO-INF2 for the study of Master Computational Sience (910). 

Students develop knowledge of the theoretical foundations of database systems and learn to program applications with integration of a relational database. 

Some basic understanding of modeling, algorithms and data structures is assumed. Lacking knowledge can eventually be easily acquired by self study. 

The theoretical lectures cover the fundamentals of database systems and offer the knowledge needed for the development of a small application with an integrated database which is the project part of the practical classes. 

 

The topics covered are: 

- Introduction, Basic Terms and Presentations 

- Fundamentals of Logical Data Organization, Relational Model 

- Database Languages (focus SQL) 

- Integrity and Security 

- Conceptual Modeling 

- Physical Data Organization, Memory-, File- and Index-Structures 

- Query Processing and Optimization 

- Transactions and Recovery 

- Programming with Database Systems 

 

In each part (theoretical and practical) there is a maximum of 50 marks achievable. The grade is derived from the sum of the two parts (i.e. a maximum of 100 marks in total). 

 

There are three possibilities to achieve marks: 

- presentation of solved homework tasks and participation in the practical part (20 marks max. - upper limit incl. bonus points) 

- hand in and presentation of a self developed project (30 marks max. - upper limit incl. bonus points) 

- theoretical test (no aids allowed, 50 marks max.) 

- presence in the practical lessons 

- hand in and presentation of a project 

- at least 15 marks at the theoretical test 

If the knockout criteria are not fulfilled, the grade is "Nicht genügend (5)". Otherwise the grade is calculated from the total amount of marks achieved according to the following table