Database Concepts (DB1 Eng)


Lecturer: Prof. Dr. Gunter Saake
Lecture: LSF-Entry
Exercise Instructor: David Broneske, Aman Kalra, Prasanna Ramesh, Victor Obionwu
Exercise: LSF-Entry

Exam Requirements

  • 60 percent of the exercise tasks need to be prepared
  • 4 tasks needs to be presented


  • The exercises start in the third week of lectures.
  • The registration for the exercise is done using LSF -- after the first lecture.
  • Link to SQLValidator for checking your SQL statements.



  • Motivation and History
  • Background Concept and Architecture
  • Data Models for Design
  • Data Models for Implementation
  • Database Design and Data Definition
  • Query and Update Operations
  • Relational Database Languages
  • Database Application Programming
  • Integrity Constrains, Transactions and Triggers
  • Views and Access Control


Slides/handouts for the lecture will be made available here during the running lecture.


  1. What are Databases?
  2. Relational Databases, Data as Tables
  3. Entity Relationship Model
  4. Database Design
  5. Relational Database Design Theory
  6. The Relational Query Language SQL
  7. Query Basics: Algebra & Calculus
  8. Transactions, Integrity & Triggers
  9. Views and Access Control
  10. Database Application Programming



  1. Exercise 1 (20.04.-24.04.)





Last Modification: 03.03.2020 - Contact Person:

Sie können eine Nachricht versenden an: Webmaster