Consider the following relational schema Employee (empno,name,office,age) Books(isbn,title,authors,publisher) Loan(empno, isbn,date) Write the following queries in relational...

 

Transcribed Image Text:

Consider the following relational schema Employee (empno,name,office,age) Books(isbn,title,authors,publisher) Loan(empno, isbn,date) Write the following queries in relational algebra. a. Find the names of employees who have borrowed a book Published by McGraw-Hill? b. Find the names of employees who have borrowed all books Published by McGraw-Hill? c. Find the names of employees who have borrowed more than five different books published by McGraw-Hill? d. For each publisher, find the names of employees who have borrowed? Given the Students relation as shown below StudentID Student Name StudentEmail StudentAge CPI 2345 Shankar shankar@math X 9.4 1287 Swati swati@ee 19 9.5 7853 Shankar shankar@cse 19 9.4 9876 Swati swati@mech 18 9.3 8765 Ganesh ganesh@civil 19 8.7 For (Student Name, Student Age) to be the key for this instance, analyze and find value of X not be equal to? Given the relations employee(name,salary,deptno) department (deptno, deptname, address) Solve which query cannot be expressed using the basic relational algebra Operations(U, -,x,,p)? Write SQL Query to find second highest salary of Employee from Employee table? Consider the following relational schema Employee (empno,name,office,age) Books(isbn,title,authors,publisher) Loan(empno, isbn,date) Write the following queries in relational algebra. a. Find the names of employees who have borrowed a book Published by McGraw-Hill? b. Find the names of employees who have borrowed all books Published by McGraw-Hill? c. Find the names of employees who have borrowed more than five different books published by McGraw-Hill? d. For each publisher, find the names of employees who have borrowed? Given the Students relation as shown below StudentID Student Name StudentEmail StudentAge CPI 2345 Shankar shankar@math X 9.4 1287 Swati swati@ee 19 9.5 7853 Shankar shankar@cse 19 9.4 9876 Swati swati@mech 18 9.3 8765 Ganesh ganesh@civil 19 8.7 For (Student Name, Student Age) to be the key for this instance, analyze and find value of X not be equal to? Given the relations employee(name,salary,deptno) department (deptno, deptname, address) Solve which query cannot be expressed using the basic relational algebra Operations(U, -,x,,p)? Write SQL Query to find second highest salary of Employee from Employee table?