Otto-von-Guericke-Universität Magdeburg

 
 
 
 
 
 
 
 

Database Concepts (DB1 Eng)

Organization

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

Exam Requirements

News 

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)
  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)
Letzte Änderung: 13.09.2017 - Contact Person: Webmaster