Given the following database:

Book(Id,Title,Publisher)

BookCopies(BookId,BranchId,NumCopies)

Branch(BranchId,BranchName,Address)

Author(BookId,authorName)

write the following queries using relational algebra. You can use intermediate relations in the case of harder expressions. Notice that there might be books with the same title published by

different publishers.

(a) List the names of the branches that have copies of books published by Addison-Wesley.

(b) For each book and branch, list the name of the book, the name of the branch, and the number of copies of the book in the branch.

(c) List the authors name for each book that has copies in the NW branch (BranchID is NW)