{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Data Mgmt Lab_Part_14

# Data Mgmt Lab_Part_14 - 40 5 Chapter 4 RA(R1...

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

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 { EN | Eid, EN, ES Employees Ceid, Caid ( Ceid, Caid Certified Aid, AN, AR ( Aid, AN, AR Aircraft Aid = Caid Eid = Ceid AR > 3000)) ¬ ( Aid 2 , AN 2 , AR 2( Aid 2 , AN 2 , AR 2 Aircraft Ceid 2 , Caid 2( Ceid 2 , Caid 2 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 highest salary. Subtract these from the original list of employees and what

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

Data Mgmt Lab_Part_14 - 40 5 Chapter 4 RA(R1...

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

View Full Document
Ask a homework question - tutors are online