Database Concepts (DB1 Eng)

Organization

Lecturer: Prof. Dr. Gunter Saake
Lecture: LSF-Entry
Exercise Instructor: David Broneske, Naveen GullipalliJohannes Wünsche
Exercise: LSF-Entry

Exam Requirements

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

News 

  • 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.
  • The exam review will take place on 25th September in G29-130. Please book a slot from the following doodle for your personal exam review: https://doodle.com/poll/9sutddnfb4prgxa3

 

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.

Introduction (PDF)

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

 

Exercise

  1. Exercise 1 (15.04.-19.04.)
  2. Exercise 2 (23.04.-26.04. -- Students of Monday's group should visit another group or send their solutions until 22.04. to their tutor via mail.)
  3. Exercise 3 (29.04.-03.05. -- Students of Wednesday's group should visit another group or send their solutions until 29.04. 1pm to their tutor via mail.)
  4. Exercise 4 (06.05. - 10.05.)
  5. Exercise 5 (13.05. - 17.05. -- ER-Notation)
  6. Exercise 6 (20.05. - 24.05.)
  7. Exercise 7 (27.05. - 31.05.  -- Wednesday from 1pm is Education Day and Thursday is Holiday. Hence, there will be no exercise classes: Students of Wednesday's and Thurdsay's group should visit another group or send their solutions until 27.05. 1pm to their tutor via mail.)
  8. Exercise 8 (03.06. - 07.06.)
  9. Exercise 9 (10.06. - 14.06. -- Students of Monday's group should visit another group or send their solutions until 10.06. to their tutor via mail.)
  10. Exercise 10 (17.06. - 21.06.)
  11. Exercise 11 (24.06. - 28.06.)
  12. Exercise 12  (01.07. - 05.07. -- practical exercises in the computer labs) Getting_Started create.sql

 

 

 

 

Last Modification: 20.08.2019 - Contact Person:

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