Formulate Relational Algebra for Queries STUDENT(#S_id, Sname, Class, Address,) ISSUE_RETURN( #S_Id, #B_id, Issue_Date, Return_Date, Dues) BOOK (#B_id, Title, Author, Publication) a.Find total number of books of Tata Mcgraw Hill Publication in the Library. b.Find the name of the student who paid the highest dues. c.Find the Return_Date of ‘Database System Concept’ book by student ‘Amar’ d.Find all the books issued by ‘Ravi’. e.Delete all records of student ‘Vinod’.

Relational Models

Three relational models are given for the entities Student, Issue_Return, and Book.

STUDENT

| S_id | Sname | Class | Address |

ISSUE_RETURN

| S_id | B_id | Issue_Date | Return_Date | Dues |

BOOK

| B_id | Title | Author | Publication |

Queries

a] Find the …