Question: Consider relations Reader ( memberid , name ) ; Book ( isbn , author,title ) ; and Borrow ( memberid , isbn,date ) . From

Consider relations Reader(memberid,name); Book(isbn,author,title); and Borrow(memberid,isbn,date). From the following expressions (relational algebra or SQL), indicate those that correctly express the query "list the names of readers who have borrowed a book by Trump". (In relational algebra we use project to indicate projections and sigma to indicate selections.)
relational algebra: sigma[author='Trump'](Borrow)
relational algebra: project[name](Reader natural-join select[author='Trump'](Book) natural-join Borrow)
SQL:
select name from Reader natural join Borrow
where author='Trump'
relational algebra: project[name](sigma[author='Trump'](Reader natural-join Book natural-join Borrow))
SQL:
select name from Reader,Book,Borrow where
Reader.memberid=Borrow.memberid and Book.isbn=Borrow.isbn and Book.author='Trump'
SQL: select * from Reader where Book.author='Trump

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!