Question
Write Relational Algebra Expression for these statements :
List all information about all books For all books Retrieve book title and the name of its publisher Retrieve the title of all books never been borrowed before How many copies of the book titled The lost tribe' are owned by the library branch whose name is 'Sharpstrown' Retrieve the names of all borrowers who do not have any books checked out. For each library branch, retrieve the branch name and the total number of books loaned out from that branch. How many copies of the book titled The Lost Tribe are owned by each library branch?
Explanation / Answer
1)info about all books:by using joins
SELECT book.book_id, book.title, book.publisher_name,book_authors.author_name
FROM book
INNER JOIN book_authors
ON book.book_id=book_authors.book_id