List the names of borrowers who currently have the book title “Lord of the Rings” on loan.

What will be an ideal response?

SELECT borrowerName
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 bc.available = ‘N’ AND title = ‘Lord of the Rings’;

Computer Science & Information Technology

You might also like to view...

____ is where the tester maps what is known about the test environment to recognized vulnerabilities.

A. Enumeration B. Discovery C. Testing D. Vulnerability mapping

Computer Science & Information Technology

What can be depicted on a sequence or communication diagram?

What will be an ideal response?

Computer Science & Information Technology