Database Management System - Old Questions

3.a)Assume a database about Company.

     EMPLOYEE (ss#, name)

     COMPANY (cname, address)

     WORKS (ss#, cname)

     SUPERVISES (supervisor_ss#, employee_ss#)

     Write relational algebra and SQL queries for each of the following cases.(5)

       (i)Find the names of all the supervisors that work in companies whose address equal ‘Kathmandu’.

       (ii)Find the names of all the companies who have more than 4 supervisors.

       (iii)Find the name of the supervisor who has the largest number of employees.