Question

use the given Diagram and the script which contains table (employees,table Job_History,Locations,Countries) to create 1.table jobs ,and table Regions. 3.answer the questions from 3 to 12. Diagram:

script with the created tables:

3.answer the questions from 3 to 13:

use the given information to resolve all questions.

Answer 1

Answered first four queries

3. SSN and Date of birth columns are not available, add the columns and insert the data to them

ALTER TABLE Employees

ADD Column SSN NUMBER(9,0) NULL,

DOB DATE NULL

4. SELECT CONCAT(First_Name,' ',Last_Name), SSN, DOB, DEPARTMENT_ID FROM "EMPLOYEES"

5. SELECT
CONCAT(First_Name, ' ', Last_Name) AS EMPLOYEE_NAME,
SALARY AS Current_SALARY,
(SALARY + 0.03 * SALARY) AS New_Salary
FROM "EMPLOYEES"

6. ALTER TABLE "JOBS" ADD CONSTRAINT "JOB_ID_PK" PRIMARY KEY("JOB_ID") ENABLE;