This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Homework 1 CSE 132A Fall 2008 Due: by noon on Tuesday Nov 4. Turn in either in class, or by sliding under Alin’s door, CSE building room 3238. This deadline is hard! I want to publish the solutions at noon, to benefit your midterm preparation. Problem 1. [100pts] Consider the following relations containing airline flight information: Flights( flno: integer , from: string , to: string , distance: integer , departs: time , arrives: time ) Aircraft( aid: integer , aname: string , cruisingrange: integer ) Employees( eid: integer , ename: string , salary: integer ) Certified( eid: integer , aid: integer ) Note that the Employess relation describes pilots and other kinds of employees as well; every pilot is certified for some aircraft (otherwise he or she would not qualify as pilot), and only pilots are certified to fly. Write the following queries in (a) relational algebra, (b) tuple relational calculus, (c) SQL. Shorthand: I will use the shorthands F,A,E,C for the relation names. 1. (10 pts): Find the eids of pilots certified for some Boeing aircraft....
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