1.Consider the relation schema given in below fig. Design and draw an ER diagram that capture the information of this schema.(Analyse)(Apr/May 2017) Employee(empno,name,office,age) Books(isbn,title,authors,publisher) Loan(empno,isbn,date) Write the following queries in relational algebra and SQL. Find the names of employees who have borrowed a book published by McGraw-Hill. Find the names of employees who have borrowed all books published by McGraw-Hill.

Consider the following schema: Books(bookID, title, publisher, year, genre)Students(studentID, name, major, age)Borrows(bookID, studentID, date) Express the following queries in SQL. a)  Print in descending order the names of all students who borrowed a book on April 1, 2021. b)  Find the titles and publishers of all books in the Science Fiction genre that are borrowed by Cybersecurity students. c)  Find the majors with average age greater than 20 years old.