Q1.Using the commands SELECT, PROJECT, and JOIN, write sequences to answer the following questions about the information in the EMPLOYEE, JOB, and ASSIGNMENT relations in Figure 9.5:

a. Obtain the name of an employee whose Job Id is S25X. b. Obtain a list of the department, skill code and job title of the employee named G. Jerry Smith. c. Obtain a list of the name and address of the employee whose start date is 5-1-2010.

Q2.Answer Problem 1 using SQL.

EMPLOYEE relation Emplld Name Address SSN 25X15 34870 23434 Joe E. Baker Cheryl H. Clark G. Jerry Smith 33 Nowhere St. 563 Downtown Ave. 1555 Circle Dr. 111223333 999009999 111005555 JOB relation Job Id Job Title Skill Code Dept S25X S26Z F5 Secretary Secretary Floor manager T5 T6 FM3 Personnel Accounting Sales ASSIGNMENT relation Emplld Job Id Start Date Term Date 4-30-2010 23Y34 34870 23Y34 S25X F5 S26Z 3-1-1999 10-1-2009 5-1-2010 Figure 9.5 An employee database consisting of three relations EMPLOYEE relation Address Emplld Name SSN 25X15 34870 23Y34 Joe E. Baker Cheryl H. Clark G. Jerry Smith 33 Nowhere St. 563 Downtown Ave. 1555 Circle Dr. 111223333 999009999 111005555 JOB relation Skill Code Job ld Job Title Dept S25x S26Z F5 Secretary Secretary Floor manager T5 T6 FM3 Personnel Accounting Sales ASSIGNMENT relation Empl Id Job Id Start Date Term Date 4-30-2010 23434 34970 23434 S25X F5 S26Z 3-1-1999 10-1-2009 5-1-2010 Figure 9.5 An employee database consisting of three relations