Database Concepts (DB1 Eng)

Organization

Lecturer: Prof. Dr. Gunter Saake
Lecture: LSF-Entry
Exercise Instructor: David Broneske, Tilman Krokotsch
Exercise: LSF-Entry

Exam Requirements

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

News 

  • The post exam review is on 10.10.2017 at 10am in G29-130. Please send a mail to David Broneske for registration and timing purposes.
  • The practical exercises take place in G29-427!
  • The registration for the exercise is done using an extra tool.
  • The exercises start in the second week of the lecture.
  • Link to SQLValidator for checking your SQL statements
  • The exercise on the 25th of April is to be canceled.

Content

  • 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

Lecture

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

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

Exercise

  1. Exercise 1 (KW 15)
  2. Exercise 2 (18.04.17 (tuesday group) or 24.04.2017 (monday group))
  3. Exercise 3 (KW 18  - students of monday's exercise either go into the tuesday exercise or send their solution via mail to David Broneske latest monday 11:59 pm)
  4. Exercise 4 (KW 19)
  5. Exercise 5 (KW 20 - ER Notation)
  6. Exercise 6 (KW 21)
  7. Exercise 7 (KW 22 - due to problems with the website, this exercise sheet is not taken into account for the final exam requirement. Everybody, who prepared solutions will get these as additional voting/presentation points.)
  8. Exercise 8 (KW 23 - students of monday's exercise either go into the tuesday exercise or send their solution via mail to David Broneske latest monday 11:59 pm)
  9. Exercise 9 (KW 24)
  10. Exercise 10 (KW 25)
  11. Exercise 11 (KW 26)
  12. Exercise 12 (KW 27 - take place in G29-427!)(Getting_Started, Create.SQL)

Last Modification: 13.09.2017 - Contact Person:

Sie können eine Nachricht versenden an: Webmaster
Sicherheitsabfrage:
Captcha
 
Lösung: