This preview shows page 1. Sign up to view the full content.
Unformatted text preview: EMP ENO ENAME TITLE E1 J. Doe Elect. Eng. E2 M. Smith Syst. Anal. E3 A. Lee Mech. Eng. E4 J. Miller Programmer E5 B. Casey Syst. Anal. E6 L. Chu Elect. Eng. E7 R. Davis Mech. Eng. E8 J. Jones Syst. Anal. ASG Formulate the query Find the names of employees who are engineers using SQL and relational algebra. (4 marks) ENO PNO RESP DUR E1 P1 Manager 12 E2 P1 Analyst 24 E2 P2 Analyst 6 E3 P3 Consultant 10 E3 P4 Engineer 48 E4 P2 Programmer 18 E5 P2 Manager 24 E6 P4 Manager 48 E7 P3 Engineer 36 E8 P3 Manager 40...
View Full Document
This note was uploaded on 10/01/2009 for the course SIT 284 taught by Professor Jam during the Spring '09 term at Alfred University.
- Spring '09