Database Concepts (DB1 Eng)

Organization

Lecturer: Prof. Dr. Gunter Saake
Lecture: LSF-Entry
Exercise Instructor: David Broneske, Naveen Gullipalli, Madhuri Hebbale 
Exercise: LSF-Entry

Exam Requirements

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

News 

  • The exam review will take place on 5th October in G29-130. Please mail David for a slot.
  • The exercises start in the third week of lectures.
  • The registration for the exercise is done using an extra tool.
  • Link to SQLValidator for checking your SQL statements.

 

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. Exercise1 (16.04.-20.04.)
  2. Exercise2 (23.04.-27.04.)
  3. Exercise3 (30.04.-04.05. - SQLValidator can be used. Important: Students of Tuesday's exercise should go this week to another exercise group or E-Mail their solutions to Madhuri befor Tuesday.)
  4. Exercise 4 (07.05.-11.05. Help: ER-Notation. Important: Students of Thursday's exercise should go this week to another exercise group or E-Mail their solutions to Madhuri before Tuesday.)
  5. Exercise 5 (14.05.-18.05.)
  6. Exercise 6 (21.05.-25.05. Important: Students of Monday's exercise should go this week to another exercise group or E-Mail their solutions to David before Tuesday.)
  7. Exercise 7 (28.05.-01.06. Updated! Important: Due to the "Tag der Lehre", there will be no exercise on Wednesday. Students of Wednesday's exercise should go this week to another exercise group or E-Mail their solutions to Naveen before Tuesday.)
  8. Exercise 8 (04.06.-08.06)
  9. Exercise 9 (11.06.-15.06.) (Updated!)
  10. Exercise 10 (18.06.-22.06.)
  11. Exercise 11 (25.06.-29.06.) (Tuesday's exercise will start at 9 am sharp!)
  12. Exercise 12GettingStartedcreate.sql (02.07.-06.07. - in the computer labs of the FIN)

 

 

 

 

 

Last Modification: 07.08.2018 - Contact Person:

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