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.

2018W, VU, 4.0h, 6.0EC

Properties

  • Semester hours: 4.0
  • Credits: 6.0
  • Type: VU Lecture and Exercise

Aim of course

The course teaches the students the basics of

  • the relational model
  • the modeling of information using the relational model
  • the use of relationales database management systems.

Students learn to abstract and model relevant facts from descriptions provided in natural language and to translate these models into relational schemas. They further learn to implement these schemas in relational database management systems, to manipulate data stored under such schemas, and to query the resulting databases. Students also learn to apply tools that allow them to measure the quality of relational schemas.

Students also learn to maintain data integrity in relational database management 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

  • Semantic Data Modelling; EER-diagrams
  • The Relational Model (Basics, Translation using EER-diagrams)
  • Relational Query Languages (Relational Algebra, Tuple/Domain Relational Calculus, SQL)
  • Design Theory for Relational Databases (Functional Dependencies, Normalforms)
  • Database programming (with pgSQL)
  • SQL-extensions
  • Transactions
  • error handling / recovery
  • multi-user synchronization

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
Mon11:00 - 13:0001.10.2018 - 26.11.2018Informatikhörsaal Lecture
Wed11:00 - 13:0003.10.2018 - 28.11.2018Informatikhörsaal Lecture
Fri11:00 - 13:0025.01.2019HS 11 Paul Ludwik Practice Lesson for Exam 2
Data Base Systems - Single appointments
DayDateTimeLocationDescription
Mon01.10.201811:00 - 13:00Informatikhörsaal Lecture
Wed03.10.201811:00 - 13:00Informatikhörsaal Lecture
Mon08.10.201811:00 - 13:00Informatikhörsaal Lecture
Wed10.10.201811:00 - 13:00Informatikhörsaal Lecture
Mon15.10.201811:00 - 13:00Informatikhörsaal Lecture
Wed17.10.201811:00 - 13:00Informatikhörsaal Lecture
Mon22.10.201811:00 - 13:00Informatikhörsaal Lecture
Wed24.10.201811:00 - 13:00Informatikhörsaal Lecture
Mon29.10.201811:00 - 13:00Informatikhörsaal Lecture
Wed31.10.201811:00 - 13:00Informatikhörsaal Lecture
Mon05.11.201811:00 - 13:00Informatikhörsaal Lecture
Wed07.11.201811:00 - 13:00Informatikhörsaal Lecture
Mon12.11.201811:00 - 13:00Informatikhörsaal Lecture
Wed14.11.201811:00 - 13:00Informatikhörsaal Lecture
Mon19.11.201811:00 - 13:00Informatikhörsaal Lecture
Wed21.11.201811:00 - 13:00Informatikhörsaal Lecture
Mon26.11.201811:00 - 13:00Informatikhörsaal Lecture
Wed28.11.201811:00 - 13:00Informatikhörsaal Lecture
Fri25.01.201911:00 - 13:00HS 11 Paul Ludwik Practice Lesson for Exam 2

Examination modalities

exercises and written examination

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Tue09:00 - 18:0017.12.2019Informatiklabor Q*bert assessedunknownSQL Test - Nachtermin
Tue09:00 - 18:0017.12.2019Informatiklabor Frogger assessedunknownSQL Test - Nachtermin
Wed09:00 - 19:0008.01.2020Informatiklabor Pong assessedon instituteAbgabegespräch
Thu09:00 - 16:0009.01.2020Informatiklabor Pong assessedon instituteAbgabegespräch
Fri09:00 - 19:0010.01.2020Informatiklabor Pong assessedon instituteAbgabegespräch
Tue09:00 - 19:0014.01.2020Informatiklabor Pong assessedon instituteAbgabegespräch
Wed09:00 - 19:0015.01.2020Informatiklabor Pong assessedon instituteAbgabegespräch
Mon18:00 - 20:0013.01.2020GM 1 Audi. Max. assessed16.12.2019 09:00 - 11.01.2020 23:59TISSPrüfung 1 - Wiederholung
Mon18:00 - 20:0013.01.2020Informatikhörsaal assessed16.12.2019 09:00 - 11.01.2020 23:59TISSPrüfung 1 - Wiederholung (Paralleltermin)
Fri18:00 - 20:0024.01.2020GM 1 Audi. Max. assessed05.01.2020 09:00 - 22.01.2020 23:59TISSPrüfung 2
Fri18:00 - 20:0024.01.2020Informatikhörsaal assessed05.01.2020 09:00 - 22.01.2020 23:59TISSPrüfung 2 (Paralleltermin)
Fri18:00 - 20:0024.01.2020EI 7 Hörsaal assessed05.01.2020 09:00 - 22.01.2020 23:59TISSPrüfung 2 (Paralleltermin)
Tue17:00 - 19:0010.03.2020EI 7 Hörsaal assessed26.02.2020 00:00 - 08.03.2020 23:59TISS1. Nebentermin (Prüfung 2) (Paralleltermin)
Wed17:00 - 19:0006.05.2020EI 7 Hörsaal assessed22.04.2020 00:00 - 04.05.2020 23:59TISS2. Nebentermin (Prüfung 2)
Thu17:00 - 19:0025.06.2020EI 7 Hörsaal assessed10.06.2020 00:00 - 23.06.2020 23:59TISS3. Nebentermin (Prüfung 2)

Course registration

Begin End Deregistration end
17.09.2018 00:00 16.10.2018 23:55 16.10.2018 23:55

Curricula

Study CodeSemesterPrecon.Info
033 526 Business Informatics 3. SemesterSTEOP
Course requires the completion of the introductory and orientation phase
033 533 Medical Informatics 3. SemesterSTEOP
Course requires the completion of the introductory and orientation phase
033 534 Software & Information Engineering 3. SemesterSTEOP
Course requires the completion of the introductory and orientation phase
033 535 Computer Engineering STEOP
Course requires the completion of the introductory and orientation phase
860 GW Optional Courses - Technical Mathematics STEOP
Course requires the completion of the introductory and orientation phase

Literature

No lecture notes are available.

Previous knowledge

There are no formal prerequisites for this course. However, it is strongly recommended to take the course "Formal Modelling" prior to this course.

Miscellaneous

Language

German