Suppose that we have the following database schema:

Book(BId, title, PName, AId) PName foreign key referencing Publisher, Aid foreign key referencing Author

Author(AId, Name)

Publisher(PName, Address, Phone)

BookLoan(BId, CardNo, DateOut, DueDate) BId foreign key referencing Book, CardNo foreign key referencing Borrower

Borrower(CardNo, Name, Address, Phone)

1- Write down the following queries in SQL:

a. Retrieve the book title and the number of its copies.

b. Retrieve the title and the due date of the book borrowed by Mshari.

c. Retrieve the number of books titled Network borrowed by Mshari

d. Give the number of borrowers who borrowed database book more than 3 times

Rewrite the queries in relational algebra language