Chapter 9, Problem 38CRP

Explanation of Solution

Sequence of operation using “JOIN”, “SELECT”, and “PROJECT”:

The sequence of operation for given SQL statement is given below:

LIST1 <- JOIN ASSIGNMENT and EMPLOYEE

    where ASSIGNMENT.EmpId = EMPLOYEE.EmpId

LIST2 <- SELECT from LIST1 where EMPLOYEE.Name = 'Joe E.Baker'

ANSWER <- PROJECT StartDate from LIST2

Explanation for above sequence:

The given SQL statement is used to list start date of employee from two relations “Assignment” and “Employee” where the value of “Name” in relation “Employee” is “Joe E.Baker”

• From the given code, the statement “LIST1 <- JOIN ASSIGNMENT and EMPLOYEE where ASSIGNMENT.EmpId = EMPLOYEE.EmpId” performs join operation...