Produce a report of book titles that have been borrowed by “Peter Bloomfield”.
What will be an ideal response?
SELECT DISTINCT title
FROM Borrower bw, Book b, BookCopy bc, BookLoan bl
WHERE bw.borrowerNo = bl.borrowerNo AND bl.copyNo = bc.copyNo
AND bc.ISBN = b.ISBN AND borrowerName = ‘Peter Bloomfield’;
Computer Science & Information Technology
You might also like to view...
Microsoft refers to a graphic representation of data in a worksheet or table as a(n):
A) graph. B) chart. C) figure. D) equation.
Computer Science & Information Technology
In Java, a sandbox provides strong protection against nuisances and denial of service (DOS) attacks.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology