Database 1
Data Manipulation
- Prof. dr. Paul M.E. De Bra
- Dept. of Computer Science
- Eindhoven Univ. of Technology
Recognizing Types of Queries for TC
- Translate the following questions (for the bank database) to the tuple calculus:
- Give the name of customers that have a loan with a branch where they also have an account.
- Give the name of customers who have a loan at a branch where they do not have an account.
- Give the name of customers who have a loan at every branch where they have an account.
- Give the name of customers who have loans only at branches where they have an account.
Library TC questions
- Give the name and faculty of borrowers, and the ISBN-number of the books of which they were the first borrower.
- Give the name and faculty of borrowers who have never borrowed the most recently purchased copy of a book.
- Give the title of books that are “present” in the library, reserved by someone, but not yet borrowed (by anyone).
Preparation for labsession 3
- You do not have to study anything new for labsession 3. You should spend the extra time on the homework.
- You should study part of SQL (chapter 4 up to and including section 4.3) by April 28.