(Solved) : Consider Following Relational Database Schema Employee Ssn Name Date Birth Address Gender Q30748968 . . .
![]()
Consider the following relational database schema Employee (Ssn, Name, Date of birth, address, gender, salary Super_Ssn, Dno.) Department(Department Number, Department Name, Manager_Ssn) Project (PNo., Pname, Control_Dnum) Works_On(ESsn,PNo.,Hours per Week) Write SQL Query for the following- (1) Update the salary of all senior employees of department number5 by 10% (2) List all employees who are not working on any project (3) Find all the department-id, name, managers, for which more than 150 employees are working (4) Retrieve names of all employees whose supervisor’s supervisor has 7001 as Ssn (5) Retrieve the names of all employees who work in the department that has employees with the highest salary among all employees Show transcribed image text
Expert Answer
Answer to Consider Following Relational Database Schema Employee Ssn Name Date Birth Address Gender Q30748968 . . .
Related