Database Management System - Old Questions

3. a) Assume a database about Company.(5)

     EMPLOYEE (ss#, name)

     COMPANY (cname, address)

     WORKS (ss#, cname)

     SUPERVISE ( superviser_ss#, employee_ss#)

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

       i) Find the names of all supervisors that work in companies whose address equals ‘pokhara’.

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

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