Answer all parts

Consider the following relational schema:

Primary keys are highlighted and underlined

authors $($

author.id$,$ lastename, first name$)$

books$($

kook.id$,$ title, num.pages, authoraid$)$

branches $($

branch.id branch name address, phone ne$)$

copies$($copv$\_$id$,$ branch$\_$id$,$ barkaid, cost$)$

loans$($loan id sapx$\_$id boxrower id due date$)$

borrowers $($

borrower.id name, member since$)$

Write SQL queries to answer the following:

$($a$)$ Using SQL Statement create a relational schema for the above entities. Remember to consider foreign keys when creating tables.

$($b$)$ Find the titles of books that have fewer than $10$ copies.

$($c$)$ Find the names of borrowers who have been members since $2005$ and have read all the books.

$($d$)$ Find the average number of pages in the books for each branch and order the result by increasing average page count.

$($e$)$ For each book$-$branch combination, find the number of copies of the book available at the branch. Give the branch name, book title, and count in the results.