This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Write the following queries in (a) relational algebra, (b) tuple relational calculus, (c) SQL. 1. (10 pts): ±ind the eids of pilots certi²ed for some Boeing aircraft. 2. (10 pts): ±ind the names of pilots certi²ed for some Boeing aircraft. 3. (20 pts): ±ind the aids of all aircraft that can be used on non-stop Fights from Boston to London. 4. (20 pts): Identify aids of all aircraft that can be piloted by every pilot whose salary is more than $100,000. 5. (20 pts): ±ind the names of pilots who can operate planes with a range greater than 3,000 miles but are not certi²ed on any Boeing aircraft. 6. (20 pts): ±ind the eids of employees who make the highest salary. 1...
View Full Document
This note was uploaded on 12/03/2009 for the course CSE 132A taught by Professor Alindeutsch during the Fall '08 term at UCSD.
- Fall '08