The Human Resources (HR) Database JOB_HISTORY PF EMPLOYEE_ID PSTART_DATE END_DATE * FJOB_ID F DEPARTMENT_ID JOBS P...

Transcribed Image Text:

The Human Resources (HR) Database JOB_HISTORY PF EMPLOYEE_ID PSTART_DATE END_DATE * FJOB_ID F DEPARTMENT_ID JOBS P JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY DEPARTMENTS P * DEPARTMENT_ID * DEPARTMENT_NAME F MANAGER_ID LOCATION_ID F JA EMPLOYEES F F * EMPLOYEE_ID FIRST_NAME * LAST_NAME EMAIL PHONE NUMBER HIRE_DATE F JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID LOCATIONS P LOCATION_ID STREET_ADDRESS POSTAL CODE * CITY STATE PROVINCE COUNTRY_ID F COUNTRIES P COUNTRY_ID F COUNTRY_NAME REGION_ID REGIONS * REGION_ID REGION NAME The above diagram shows the tables and columns of the major tables used in the HR database, which are installed on the CIT classroom PCs and which you will install in your home PC once you've followed the setup instructions provided in eLearn. The local Union representative is claiming that the annual salaries of Programmers in the IT Department are under paid. Use SQL Developer to look at the contents of these database tables to find the data referred to in the questions below. Do a SELECT * FROM Jobs; and the other tables to see the contents. Give the column names where the data is found. 1. What information is required from the database to display the information (that will show whether actual Programmers in the IT Department are under paid or not)? The Human Resources (HR) Database JOB_HISTORY PF EMPLOYEE_ID PSTART_DATE END_DATE * FJOB_ID F DEPARTMENT_ID JOBS P JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY DEPARTMENTS P * DEPARTMENT_ID * DEPARTMENT_NAME F MANAGER_ID LOCATION_ID F JA EMPLOYEES F F * EMPLOYEE_ID FIRST_NAME * LAST_NAME EMAIL PHONE NUMBER HIRE_DATE F JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID LOCATIONS P LOCATION_ID STREET_ADDRESS POSTAL CODE * CITY STATE PROVINCE COUNTRY_ID F COUNTRIES P COUNTRY_ID F COUNTRY_NAME REGION_ID REGIONS * REGION_ID REGION NAME The above diagram shows the tables and columns of the major tables used in the HR database, which are installed on the CIT classroom PCs and which you will install in your home PC once you've followed the setup instructions provided in eLearn. The local Union representative is claiming that the annual salaries of Programmers in the IT Department are under paid. Use SQL Developer to look at the contents of these database tables to find the data referred to in the questions below. Do a SELECT * FROM Jobs; and the other tables to see the contents. Give the column names where the data is found. 1. What information is required from the database to display the information (that will show whether actual Programmers in the IT Department are under paid or not)?