Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SECTION A [20 Marks The following are the ER Diagram for the HR Database and table structure for the employees. Write the query statements for
SECTION A [20 Marks The following are the ER Diagram for the HR Database and table structure for the employees. Write the query statements for all the questions (Questions 1-4). HR DEPARTMENTS department_id department name manager_id location_id LOCATIONS location_id street_address postal code city state province country_id JOB_HISTORY employee id start date end_date job_id department_id COUNTRIES country id country name region_id EMPLOYEES employee_id first name last name email phone number hire_date job_id salary commission pct manager_id department_id JOBS job_id job_title min_salary max_salary REGIONS region_id region_name Figure 1 Employee table Structure Name Null? Type NOT NULL NOT NULL NOT NULL EMPLOYEE ID FIRST NAME LAST NAME EMAIL PHONE NUMBER HIRE DATE JOB ID SALARY COMMISSION PCT MANAGER ID DEPARTMENT_ID NOT NULL NOT NULL NUMBER (6) VARCHAR2 (20) VARCHAR2 (25) VARCHAR2 (25) VARCHAR2 (20) DATE VARCHAR2 (10) NUMBER (8,2) NUMBER (2,2) NUMBER (6) NUMBER (4) Figure 2 1. The HR department has requested a report of all employees and their job IDs. Display the first name, last name concatenated with the job ID (separated by a comma) and name the column Employee and Title. [4 Marks) Sample output Employee and Title Joe, King, AD PRES Young, Ernst, IT_PROG
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started