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.

2019W, VU, 2.0h, 3.0EC

Properties

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

Learning outcomes

After successful completion of the course, students are able to

  • devise mechanisms for guaranteeing given integrity constraints in a relational schema and to implement them in SQL on a relational database management system (RDBMS);
  • comprehending and developing database queries using advanced SQL language features;
  • 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

  • Database programming (with pgSQL)
  • SQL-extensions
  • Transactions
  • error handling / recovery
  • concurrency control

Teaching methods

  • The topics of the course are presented during the lectures
  • In the exercise part of the course, the application of the presented methods, concepts, and algorithms are trained.
  • The exercise part consists of two exercise sheets, which are solved by the students as  a homework and handed in.
  • Ahead of the deadlines, teaching assistants offer consultation hours.
  • The first exercise is checked by the teaching assistants and returned to the students (enhanced with some feedback)
  • The correct solutions are presented by the lecturers and discussed with the audience in extra lectures.
  • The second exercise is dicussed with a teaching assistant in a personal meeting. During the discussion the solutions will be checked for correctness, and even more the students understanding of the topic are evaluated and feedback is provided.

Mode of examination

Immanent

Additional information

Note:

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
0,5h exercise interview
18h exam preparation
 1,5h exam
-----------------
75h (= 25h * 3ECTS)

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Wed11:00 - 13:0002.10.2019Informatikhörsaal Organisational Meeting (Shared with VU 184.686 Database Systems)
Mon11:00 - 13:0004.11.2019 - 02.12.2019Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed11:00 - 13:0006.11.2019 - 27.11.2019Informatikhörsaal Lecture (parallel to VU Database Systems)
Data Modelling - Single appointments
DayDateTimeLocationDescription
Wed02.10.201911:00 - 13:00Informatikhörsaal Organisational Meeting (Shared with VU 184.686 Database Systems)
Mon04.11.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed06.11.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Mon11.11.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed13.11.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Mon18.11.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed20.11.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Mon25.11.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Wed27.11.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)
Mon02.12.201911:00 - 13:00Informatikhörsaal Lecture (parallel to VU Database Systems)

Examination modalities

The final evaluation is based on the performance at the exercises (evaluation of the first exercise sheet is based on the submission, evaluation of the second exercise sheet also heavily depends on the performance at the meeting with the Tutor) and a written exam.

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Tue17:00 - 19:0010.03.2020EI 7 Hörsaal assessed13.02.2020 09:00 - 09.03.2020 09:00TISS1. Nebentermin (Prüfung 1)
Wed17:00 - 19:0006.05.2020EI 7 Hörsaal assessed22.04.2020 09:00 - 04.05.2020 23:59TISS2. Nebentermin (Prüfung 1)
Thu17:00 - 19:0025.06.2020EI 7 Hörsaal assessed10.06.2020 09:00 - 23.06.2020 23:59TISS3. Nebentermin (Prüfung 1)

Course registration

Begin End Deregistration end
08.09.2019 09:00 15.10.2019 23:55 15.10.2019 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