Homework 1 Solutions

# Homework 1 Solutions - Homework 1 CSE 132A Fall 2008 Due:...

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
This is the end of the preview. Sign up to access the rest of the 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.

### Page1 / 4

Homework 1 Solutions - Homework 1 CSE 132A Fall 2008 Due:...

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

View Full Document
Ask a homework question - tutors are online