Chapter 9, Problem 33CRP

Explanation of Solution

Given code:

TEMP1 <- JOIN EMPLOYEE and ASSIGNMENT

   where EMPLOYEE.EmpId =

     ASSIGNMENT.EmpId

TEMP2 <- SELECT from TEMP1 where

   TermDate = '*'

RESULT <- PROJECT name, StartDate

   from TEMP2

Code Explanation:

• The given code is used to lists the “name” and “StartDate” from relations “EMPLOYEE” and “ASSIGNMENT” where the value of “EmpId” is equal in both relations and the value of “TermDate” is “*”.
• From the given code, the statement “TEMP1 <- JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmpId = ASSIGNMENT...