Question: Consider relations Reader ( memberid , name ) ; Book ( isbn , author,title ) ; and Borrow ( memberid , isbn,date ) . From
Consider relations Readermemberidname; Bookisbnauthor,title; and Borrowmemberidisbn,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: sigmaauthor'Trump'Borrow
relational algebra: projectnameReader naturaljoin selectauthor'Trump'Book naturaljoin Borrow
SQL:
select name from Reader natural join Borrow
where author'Trump'
relational algebra: projectnamesigmaauthor'Trump'Reader naturaljoin Book naturaljoin Borrow
SQL:
select name from Reader,Book,Borrow where
Reader.memberidBorrow.memberid and Book.isbnBorrow.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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
