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.


  • In the week starting May 21st because of the public holiday there will be no lecture and excersises
  • We've got a  bigger room! Starting April 23rd the lecture will take place in G22A-013!!!
  • Exercises will start in the week starting April 23rd

Lecture and Exercise Materials

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

Advanced Database Models (PDF slides) 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

Additional notes on tasks priveded by tutor Taranpreet Kaur: Adbm2018.pdf


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


Last Modification: 09.07.2018 - Contact Person:

Sie können eine Nachricht versenden an: Webmaster