List the names of borrowers who currently have the book title “Lord of the Rings” on loan.
What will be an ideal response?
RA: ? borrowerName ( ( (? title=‘Lord of the Rings’ (Book)) ISBN (? available=‘N’ (BookCopy)) )
copyNo (BookLoan) borrowerNo (Borrower) )
TRC: {BW.borrowerName | Borrower(BW) ? (?BL) (?B) (?BC) (Book(B) ?
BookCopy(BC) ? BookLoan(BL) ? (BC.ISBN = B.ISBN) ?
(BW.borrowerNo = BL.borrowerNo) ? (BL.copyNo = BC.copyNo) ?
(BC.available=‘N’) ? (B.title= ‘Lord of the Rings’))}
DRC: {borrowerName | (?ISBN, title, edn, yr, copyNo, avail, bNo, bAddress, dOut,
dDue) (Book(ISBN, title, edn, yr) ? BookCopy(copyNo, ISBN, avail) ?
Borrower(bNo, borrowerName, bAddress) ? BookLoan(copyNo, dOut,
dDue, bNo) ? avail=’N’ ? title= ‘Lord of the Rings’)}
You might also like to view...
If a chart is selected, a(n) ________ border surrounds the data that represents the legend labels
A) purple B) orange C) blue D) green
Which of the following code segments prints a single line containing hello there with the words separated by a single space?
a. std::cout << "hello "; std::cout << " there"; b. std::cout << "hello" , " there"; c. std::cout << "hello"; std::cout << "there"; d. std::cout << "hello"; std::cout << " there";