Jordan University of Science and Technology Information Systems Department CIS221Fundemantal of Database Internal Lab Name: ID: Assignment #4 Depending on the below schema answer all the question: EMPLOYEE Frame Minit Lname Bdate Address Sex Salary Super_ssn Dno Son 4411 DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship 1) Write appropriate query to find the number of employees who have supervisor? 2) Retrieve all information for female employee; order the result in ascending order according to salary column. 3) Retrieve project name and department name for each project assigned to specific department. 4) Retrieve the first name for employees who have salary same as Sami's salary