Consider the following Employee database and sample data. You may wish to add more data records. Employee (empId, name,
Posted: Thu Jul 14, 2022 2:28 pm
Consider the following Employee database and sample data. Youmay wish to add more data records. Employee (empId, name, address,DOB, job, salaryCode, deptId, manager, schemeId) Department(deptId, name) SalaryGrade (salaryCode, startSalary, finishSalary)PensionScheme (schemeId, name, rate)
1. Use appropriate data types and write the Oracle SQLstatements to create the tables defined in the schema above.
2. Write SQL Statements to return the following data from theEmployee database:
a) The name (in ascending order), the starting salary anddepartment id of each employee within a descending order ofdepartment ids.
b) Give the number of employees for each of the pension schemesoffered by the company. Result listing should include the name ofeach scheme and its corresponding number of employees who join thescheme.
c) Give the total number of employees who are not managers butcurrently receive an annual salary of over £35,000.
d) List the id and name of each employee along with his/hermanager’s name.
TARIF. FinnlnyDด
TABLE: Department
TABLE: PensionScheme
- Consider The Following Employee Database And Sample Data You May Wish To Add More Data Records Employee Empid Name 1 (284 KiB) Viewed 39 times
2. Write SQL Statements to return the following data from theEmployee database:
a) The name (in ascending order), the starting salary anddepartment id of each employee within a descending order ofdepartment ids.
b) Give the number of employees for each of the pension schemesoffered by the company. Result listing should include the name ofeach scheme and its corresponding number of employees who join thescheme.
c) Give the total number of employees who are not managers butcurrently receive an annual salary of over £35,000.
d) List the id and name of each employee along with his/hermanager’s name.
TARIF. FinnlnyDด
TABLE: Department
TABLE: PensionScheme