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 ‘Biratnagar'.

       ii)Find the name of all the companies who have more than 10 employees.

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