1.

SELECT ISBN,title

FROM Book

WHERE author = ‘Arthur Miller’

2.

SELECT Book.bookID, Book.title

FROM Book,Member,CurrentLoan

WHERE (Member.firstname = ‘John’ AND Member.lastname = ‘Smith’ and Member.memberID = CurrentLoan.memberID)

3.

SELECT bookID as id

FROM Book

WHERE title = ‘Da Vinci Code’

SELECT Member.firstname, Member.lastname

FROM Member, Book, CurrentLoan, History

WHERE (CurrentLoan.memberID = Member.memberID AND History.memberID = Member.memberID AND CurrentLoan.bookID = id AND History.bookID = id)

4.

SELECT memberID,firstname,lastname

FROM Member

NATURAL LEFT JOIN History

WHERE loan-date IS NULL