Hasso-Plattner-Institut
Prof. Dr. Tilmann Rabl
  
 

Database Systems I

Instructors

Prof. Dr. Tilmann RablDr. Pedro SilvaLawrence BensonIlin Tolovski

Contents

Databases are at the core of almost all large applications and are used in all enterprises. In this lecture, we will discuss database systems from an application perspective. We will start with an introduction to the SQL querying language, i.e., how we can create, update and search data tables. Next, we will look into modelling databases by using ER diagrams and relational models. We will also dig into the relational algebra that enables us to operate on top of the relational models. In the second part of the lecture, we will discuss advanced topics such as transaction management, programming database systems through database-access APIs such as JDBC. We will touch on the topic of security, discussing threats such as SQL injection.

Announcements

  • The moodle page for the course is now open for students. You can enroll here.
  • Course management will be done using the Algorithm Engineering Moodle
  • Non-HPI participants: please send us an email to get access to the Moodle
  • Due to the ongoing corona virus situatuion, the course will be conducted online (at least for the beginning). 

Schedule

The lectures will be available in video format on tele-TASK or in the Algorithm Engineering Moodle. The live exercise sessions will take place in smaller groups in Zoom conferences on Tuesdays and Thursdays at 11am. The assignment of students to exercise groups will be done once the list of participants is complete.

Topics

Will be announced in Moodle.

Grading

  • The grade will be determined in a written exam.
  • The time and location of the exam will be announced at least 6 weeks in advance.
  • The prerequisite for admission to the exam is the successful completion of the exercises (> 50% of the total points of the exercises, and > 50% of the programming exercise).
  • In case of low participation, the exam might be replaced by an oral examination.

Structure

Lectures

The lectures will be conducted online and available in video format on tele-TASK or in the Algorithm Engineering Moodle.

Exercises

  • There will be 7 graded exercises in the form of homework exercises or moodle quizzes. 
  • Each week there will be group sessions where we will discuss problems and solve examples related to the exercises. 
  • The students will need at least 50% of the total points to be eligible to take the final exam. 
  • These points will not count when forming the final grade.

Programming exercise

  • There will be 1 graded programming exercise. 
  • In order to be eligible for the final exam, the students need to achieve at least 50% of the points of this exercise
  • These points will not count when forming the final grade.
  • Submission deadline: TBD

Final exam

  • Date: TBD
  • Prerequisites: > 50% of the total exercise points, > 50% of the programming exercise points
  • Written exam, 100% of the final grade.

Literature

Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems - The Complete Book, Pearson Education International, 2008 (available in the UP library and at our chairs library)

Other books

  • Alfons Kemper, André Eickler: Datenbanksysteme - Eine Einführung, De Gruyter Oldenbourg, 2015
  • Gunter Saake, Andreas Heuer, Kai-Uwe Sattler - Datenbanken: Konzepte und Sprachen, mitp Verlags GmbH & Co, 2018
  • Elmasri Ramez And Navathe Shamkant: Fundamentals of Database Systems, Pearson India, 2017
DateTopic
TU 14.04. 
TH 16.04. 
TU 21.04. 
TH 23.04. 
TU 28.04.Introduction
TH 30.04.SQL Primer
TU 05.05.SQL Primer II
TH 07.05. 
TU 12.05.ER Model
TH 14.05.ER Model II
TU 19.05.Modern Hardware
TH 21.05.Ascension Day
TU 26.05.Relational Model
TH 28.05. 
TU 02.06.Relational Algebra
TH 04.06.Relational Algebra
TU 09.06.SQL
TH 11.06.SQL
TU 16.06.Integrity Constraints
TH 18.06.Integrity Constraints
TU 23.06.Transaction Mgmt
TH 25.06.Transaction Mgmt
TU 30.06.JDBC
TH 02.07.JDBC
TU 07.07.Query Processing
TH 09.07.Query Processing
TU 14.07.DB Security
TH 16.07.DB Security
TU 21.07.Outlook
TH 23.07.Outlook
TH 30.07. 
TH 07.08., 10 AMExam, HS 1, 2 and 3