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.

2020W, VU, 4.0h, 6.0EC
TUWEL

Properties

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

Learning outcomes

After successful completion of the course, students are able to

  • interpret concepts of ER- and EER- models as well as the relational data model and apply them in order to express given facts;
  • abstract relevant concepts from a situation described in natural language, model them in ER- and EER- diagrams and derive relational schemas from such models;
  • devise relational schemas (including mechanisms for guaranteeing given integrity constraints on the data) and to implement them in SQL on a relational database management system (RDBMS);
  • assess and improve the quality of a relational schema;
  • manipulate and query data stored under a relational schema using SQL;
  • comprehend and independently formulate database queries in SQL, the Relational Algebra, and the Relational Calculus (this includes being able to formalize requests/queries given as natural language);
  • 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

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

Teaching methods

  • This course will be held in a distance-learning format, except for the exams.
  • This course will be held both in English and in German: the lectures, the exercise, and the exams will be available in both languages.
  • 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 exercise sheets, which are solved by the students as a homework and handed in.
  • Practicing the formulation of SQL queries is done in an online tool.
  • Ahead of the deadlines questions can be asked in the forum, teaching assistants will answer them there.
  • Exercises are discussed and checked by teaching assistants.

 

Mode of examination

Immanent

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

Examination modalities

The final evaluation is based on the performance in the exercise part and two written exams.

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Fri - 03.12.2021written19.11.2021 00:00 - 01.12.2021 12:00TISSTest 1
Mon - 10.01.2022written27.12.2021 00:00 - 08.01.2022 12:00TISSTest 1 Nebentermin
Fri - 21.01.2022written01.01.2022 00:00 - 19.01.2022 12:00TISSTest 2
Fri - 04.03.2022written11.02.2022 00:00 - 02.03.2022 12:00TISSTest 2 Nebentermin

Course registration

Begin End Deregistration end
14.09.2020 00:00 20.10.2020 23:55 20.10.2020 23:55

Registration modalities

Please notice that it is not allowed to register both for this course and for the course "Data Modelling". Students enrolled for both courses simultaneously will be removed from both courses.

Registrations from students from Informatics, Business Informatics, Mathematics, and Data Science Master will be confirmed. Confirmations of registrations from other studies depend on capacity.

Curricula

Study CodeSemesterPrecon.Info
033 201 Technical Mathematics STEOP
Course requires the completion of the introductory and orientation phase
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