Hi, I am stuck on doing a NOT IN or NOT EXISTS in sql

The question is "Display the titles of books that haven't been borrowed."

It it for a library database.

The database schema is as follows

borrow(transactionID, personID*, borrowdate, duedate, returndate)

author(authorID, firstname, middlename, lastname)

book_copy(bookID, bookdescID*)

book(bookdescID, title, subtitle, edition, voltitle, volnumber, language, place, year, isbn, dewey, subjectID*)

borrow_copy(transactionID*, bookID*)

person(personID, firstname, middlename, lastname, address, city, postcode, phonenumber, emailaddress, studentno, idcardno)

publisher(publisherID, publisherfullname)

written_by(bookdescID*, authorID*, role)

published_by(bookdescID*, publisherID*, role)

subject(subjectID, subjecttype)

SophiaPretty

(5)

Status NEW Posted 16 Dec 2017 06:12 AM My Price 6.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

• Buy Answer