Data Mgmt Lab_Part_14 - 40 Chapter 4 5. RA ( R 1 , eid (

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 40 Chapter 4 5. RA ( R 1 , eid ( cruisingrange> 3000 ( Aircraft ./ Certified ))) ename ( Employees ./ ( R 1 eid ( aname = Boeing ( Aircraft ./ Certified )))) TRC { E.ename | E Employees C Certified ( A Aircraft ( A.aid = C.aid E.eid = C.eid A.cruisingrange > 3000)) ( C 2 Certified ( A 2 Aircraft ( A 2 .aname = Boeing C 2 .aid = A 2 .aid C 2 .eid = E.eid ))) } DRC {h EN i | h Eid, EN, ES i Employees Ceid, Caid ( h Ceid, Caid i Certified Aid, AN, AR ( h Aid, AN, AR i Aircraft Aid = Caid Eid = Ceid AR > 3000)) ( Aid 2 , AN 2 , AR 2( h Aid 2 , AN 2 , AR 2 i Aircraft Ceid 2 , Caid 2( h Ceid 2 , Caid 2 i Certified Aid 2 = Caid 2 Eid = Ceid 2 AN 2 = Boeing ))) } SQL SELECT E.ename FROM Certified C, Employees E, Aircraft A WHERE A.aid = C.aid AND E.eid = C.eid AND A.cruisingrange > 3000 AND E.eid NOT IN ( SELECT C2.eid FROM Certified C2, Aircraft A2 WHERE C2.aid = A2.aid AND A2.aname = Boeing ) 6. RA The approach to take is first find all the employees who do not have the...
View Full Document

This note was uploaded on 01/17/2012 for the course EGN 4302 taught by Professor Dr.vishak during the Fall '12 term at University of Central Florida.

Page1 / 3

Data Mgmt Lab_Part_14 - 40 Chapter 4 5. RA ( R 1 , eid (

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online