Answer
See explanation
Work Step by Step
a. Obtain the name of an employee whose Job ID is S25X.
TEMP1 ← SELECT from ASSIGNMENT where ASSIGNMENT.JobId = “S25X”
TEMP2 ← PROJECT EmplId from TEMP1
TEMP3 ← JOIN TEMP2 and EMPLOYEE where EMPLOYEE.EmplId = TEMP2.EmplId
RESULT ← PROJECT Name from TEMP3.
b. Obtain a list of the department, skill code and job title of the employee named G. Jerry
Smith.
TEMP1 ← SELECT from EMPLOYEE where EMPLOYEE.Name = “G. Jerry Smith”
TEMP2 ← PROJECT EmplId from TEMP1
TEMP3 ← JOIN TEMP2 and ASSIGNMENT where ASSIGNMENT.EmplId = TEMP2.EmplId
TEMP4 ← PROJECT JobId from TEMP3
TEMP5 ← JOIN TEMP4 and JOB where JOB.JobId = TEMP4.JobId
RESULT ← PROJECT Department, SkillCode and JobTitle from TEMP5.
c. Obtain a list of the name and address of the employee whose start date is 5-1-2010.
TEMP1 ← SELECT from ASSIGNMENT where ASSIGNMENT.StartDate = “5-1-2010”
TEMP2 ← PROJECT EmplId from TEMP1
TEMP3 ← JOIN TEMP2 and EMPLOYEE where EMPLOYEE.EmplId = TEMP2.EmplId
RESULT ← PROJECT Name, Address from TEMP3.
