questions have been asked by Management in the latest business performance review. You have to address
Question:
questions have been asked by Management in the latest business performance review.
You have to address the below questions in chronological order.
Based on the Database Schema diagram below it is up to you to determine which table should be queried.
Type your response in the Answer column and upload the file on PRISM platform for verification.
Note: You must open this PDF in Adobe Reader to type your answer. You cannot type when you open this PDF in web browser.
# | Management Request | Hint | Answer |
1 | Management would like a report showing the DEPARTMENTS in the business. This should include the DEPARTMENT NUMBER and NAME only.
Use the schema prefix in your table reference e.g. EMPLOYEES.SALARIES |
| Answer |
2 | Management is interested in the Finance department and would like to see the Employee Numbers for all Managers in the Finance department.
Perform a Query that returns the Employee Number only for managers that are in the Finance department - this should include all managers past and present.
Use the schema prefix in your table reference e.g. EMPLOYEES.SALARIES | Use the WHERE clause with the department code for Finance in the search condition in the target table | Answer |
3 | Based on your result from the previous question management are interested in Employee 110114. They would like to know the name and gender of this employee.
Perform a query that returns the first name, last name
| You will need to use the WHERE clause | Answer |
Auditing a risk based approach to conducting a quality audit
ISBN: 978-1133939153
9th edition
Authors: Karla Johnstone, Audrey Gramling, Larry Rittenberg