1. Find the names of all authors of books published by "Pearson" that cost more than $100.

2. Find the names of all borrowers who have borrowed books that are overdue. Notes: You can use the actual date at the time when you solve the assignment to verify whether a book loan is overdue. Also, assume that date comparison is available in relational algebra; for example, '12-Jan-2020'

3. For each library branch, list its name and how many copies of the book titled "The Lost Tribe" it owns.

1. d)How many copies of the book titled "The Lost Tribe" are owned by the library branch whose name is "Sharpstown"?

e)Find the names of all members who have not borrowed any books from the library.

Relational algebra. Consider the following relational schema for a library: book book_id varchar title varchar publisher varchar author varchar price number varchar varchar book_copies book_id branch_id no_of_copies borrower card_no varchar varchar varchar book_loans book_id branch_id card_no date_out due_date name varchar number varchar address number date phone varchar date varchar