(+5) Based on the EMPLOYEE, JOB and ASSIGNMENT relations in figure 9.5, what is the name of the person who works as a secretary in the Accounting Dept.

HINT: Q & E page 419

Joe E Baker

Cheryl H Clark

Cannot be determined

G Jerry Smith

(+5) Based on the EMPLOYEE, JOB and ASSIGNMENT relations in figure 9.5, in what is the job title of employee Cheryl H Clark

Secretary

Floor Manager

Cannot be determined

Sales

(+5) Based on the EMPLOYEE, JOB and ASSIGNMENT relations in figure 9.5, in what job does G Jerry Smith currently hold

S25X

S26Z

Cannot be determined

F5

(+5) Based on the EMPLOYEE, JOB and ASSIGNMENT relations in figure 9.5, will the following sequence of relational operations obtain a list of job titles within the personnel department

TEMP SELECT from JOB where Dept = Personnel

PROJECT JobTitle from TEMP

True

False

(+5) Chapter Review # 13 on page 440

Answers a and cprovided Only b is required

a. TEMP SELECT from Manufacturer where PartName = "bolt 2Z"

RESULT PROJECT CompanyName from TEMP

c. TEMP1 JOIN PART and Manufacturer

where PART.PartName = MANUFACTURER.PartName

TEMP2 SELECT from TEMP1 where PART.Weight = 1

RESULT PROJECT Manufacturer.CompanyName from TEMP2

b. Which of the following answers the query:Obtain a list of the parts made by Company X along with each parts cost ?

TEMP SELECT from MANUFACTURER where CompanyName = COMPANY X

RESULT PROJECT PartName from TEMP

TEMP SELECT from MANUFACTURER where CompanyName = COMPANY X

RESULT PROJECT PartName, Cost from TEMP

TEMP SELECT from MANUFACTURER where CompanyName = COMPANY X

RESULT PROJECT Cost from TEMP

None of the above

(+5) Given the two relations X and Y below

X: A B Y: C D

2 s t 1

5 z r 3

w 2

what values would be in the relation produced by the following statement?

Result JOIN X and Y where X.A < Y.D

a. 2, s, r, 3

b. 2, s, w, 2

c. 2, s, t, 1

d. 5, z, r, 3