Find the first name, last name, and salary of all employees who have the highest salary. (1.5 point) Query Text: Query Output: 5) Find the first name, last name, and salary of all employees who have 3 dependents.(1.5 point) Query Text: Query Output: 7) Show how can you insert a new row to the DEPT_LOCATIONS table using the following details: (1 point) Dnumber=1 DIocation=Bradford Include the insert command and a screen shot of the DEPT_LOCATIONS table showing the new row. 8) Show how can you raise the salaries of all employers in department 5 by 2%. Include the update command and a screen shot of the EMPLOYEE table but only for the employees in department 5 to make sure that the salaries have been increased by 2%. (1.5 point)

 

EMPLOYEE Bdate Address Ssn 123456789 1965-01-09 731 Fondren, Houston, TX M 1955-12-08 638 Voss, Houston, TX M F Fname Minit Lname John B Smith Franklin T Wong 333445555 Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX James E Borg 888665555 1937-11-10 450 Stone, Houston, TX F DEPARTMENT Dname Research Administration Headquarters WORKS ON Essn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Dnumber 5 4 1 Pno 1 2 3 1 2 2 3 10 20 30 10 10 30 30 20 20 Hours 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 Figure 5.6 One possible database state for the COMPANY relational database schema. 20.0 15.0 NULL Mgr_ssn 333445555 987654321 888665555 DEPENDENT Essn 333445555 333445555 333445555 987654321 123456789 123456789 123456789 Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 PROJECT Pname ProductX ProductY ProductZ Computerization Reorganization Newbenefits Sex Salary Super_ssn Dno 30000 333445555 5 40000 888665555 5 25000 987654321 4 43000 888665555 4 38000 333445555 5 25000 333445555 5 4 25000 987654321 55000 NULL 1 Alice Theodore Joy Abner Michael Alice Elizabeth M F M M Dependent_name Sex F DEPT LOCATIONS Pnumber 1 2 3 M F M M F F Dnumber 1 4 5 5 5 10 20 30 Plocation Bellaire Sugarland Houston Stafford Houston: Stafford Dlocation Houston Stafford Bellaire Sugarland Houston Dnum 5 5 5 4 1 4 Bdate 1986-04-05 1983-10-25 Son 1958-05-03 1942-02-28 1988-01-04 1988-12-30 Daughter 1967-05-05 Spouse Relationship. Daughter Spouse Spouse Son