7. Find the names of female employees who work on projects controlled by the 'Finance' department....

  

Transcribed Image Text:

7. Find the names of female employees who work on projects controlled by the 'Finance' department. Using the Schema in Figure 1.2. (20 points) 8. Retrieve a list of names, bdate, relationship of dependents of each male employee in the 'Research' department. Using the Schema in Figure 1.2. (20 points) EMPLOYEE FNAME MINIT LNAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT_LOCATIONS DNUMBER PROJECT PNAME PNUMBER DEPENDENT ESSN DLOCATION PLOCATION DNUM WORKS ON ESSN PNO HOURS DEPENDENT NAME SEX BDATE RELATIONSHIP 7. Find the names of female employees who work on projects controlled by the 'Finance' department. Using the Schema in Figure 1.2. (20 points) 8. Retrieve a list of names, bdate, relationship of dependents of each male employee in the 'Research' department. Using the Schema in Figure 1.2. (20 points) EMPLOYEE FNAME MINIT LNAME SSN BDATE ADDRESS SEX SALARY SUPERSSN DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT_LOCATIONS DNUMBER PROJECT PNAME PNUMBER DEPENDENT ESSN DLOCATION PLOCATION DNUM WORKS ON ESSN PNO HOURS DEPENDENT NAME SEX BDATE RELATIONSHIP