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

DEPT_EMP EMP_NO DEPT_NO FROM_DATE TO_DATE INT PK CHAR(4) PK DATE DATE DEPARTMENTS DEPT_NO CHAR(4) PK DEPT_NAME VARCHAR(40) EMPLOYEES EMP_NO BIRTH DATE FIRST_NAME LAST_NAME GENDER HIRE_DATE DEPT MANAGER EMP_NO DEPT_NO INT PK DATE VARCHAR(14) VARCHAR(16) ENUM('M','F') DATE FROM_DATE TO_DATE INT PK CHAR(4) PK DATE DATE SALARIES EMP_NO SALARY FROM_DATE TO_DATE EMP_NO TITLE FROM_DATE TO_DATE TITLES INT PK INT DATE PK DATE INT PK VARCHAR(50) PK DATE PK DATE