Advanced Database Models

prac4.txt Organization

Lecturer:  Dr. Eike Schallehn
Lecture:  LSF-Entry
Exercise:  LSF-Entry

Exam requirements

  • The exam will take place as a written exam. Registration using the LSF/HISQUIS system is required according to the general procedures.
  • Participation in the lecture and in the exercise is required.


  • Practical exercises will start on Monday, May 29th.
    There will be no exercises on Tuesday, May 30th, and Friday, June 2nd.
    There will be no exercise on Monday, June 5th.
    Practical exercises will continue on Tuesday, June 6th, and Friday, June 9th.
  • Because of public holiday there will be no lectures on April 17th. May 1st and June 5th

Lecture and Exercise Materials

Lecture handouts will be made available here over the course of the lecture.

Advanced Database Models (PDF slides)

Exercise sheets  will be made available here over the course of the lecture.

  1. Basic Terms and Concepts [PDF]
  2. Principles of Databases [PDF]
  3. Relational Algebra
  4. Conceptual Design
  5. NF2
  6. NF2 with Oracle
    Some guidelines for working with Oracle can be found here.
    Solution: prac1.sql
  7. Object-relational with Oracle
    Solution: prac2.sql
  8. Recursive Queries and Methods
    Solution: prac3.sql
  9. XML, DTDs, XPath and XQuery
    Use for the XPath and XQuery tasks.
    Solution: prac4.txt


Literature references and recommended readings are listed in the lecture handouts.


Last Modification: 04.07.2017 - Contact Person:

Sie können eine Nachricht versenden an: Webmaster