Question

Question #33: On the basis of the database

Olems 513 is answered by the following program segment: TEMP1 6 JOIN EMPLOYEE and ASSIGNMENT where EMPLOYEE.EmplId = ASSIGNMENT. EmplId TEMP2 SELECT from TEMP1 where TermDate = '* RESULT PROJECT name, StartDate from TEMP2

represented in Figure 9.5, state the question that is answered by the following program segment:

Answer 1

Date: 1 After first statement of sal Temp1 will contain the elements from the cross booduct of Employee and assiga E where Employee. Id = Assigment. Td Temb la EmpId Name Address SSN Jab Id start Date Teom Date 10-1-2009 * 23734 G. Jerrys 3-1-1999 4-30-2010 - 3-1 -1999 134770 Cheryl H. C a a a 23134 G. Jerrys After second statement of sql All the rows having term Date as '*' will be selected to temp a. Temp 2: Emb Id 34470 123434 Name Address Cherylnica C. Teosys " SSN " " Job id " " Start Date 10-1-2009 3-1-1999 Tom Rate! * * Alter Nome third and startement of sal start date will be selected Result: I Name Cheryl H. Clark G. Terry Smith start Date 10-1-2009 3-1-1999

Page No. Date: / / The question for these statement con be Point name & start date of employess whose working on assigment having Heom 'x' a bir na the a bate as

Please Let me know in the comment section if you have any doubt.