Question

Answer only in the form of symbol relational algebra. Consider the following relations and relationship:

Passenger(passengerNo, name, gender, address, phone)

Flight (flightNo, airline, plane, departure_city, arrival, distance)

Booking(passengerNo, flightNo, date, cost)

1. List the flightNo and airline of all the flights whose departure_city is houston

2. List the maximum, minimum, and average distance of the flights

3. List the passengerNo, name of all the passengers who have arrival on Houston

Answer 1

1.∏flightNo, airline(σ departure_city="houston" (Flight))

2.for the maximum

∏ distance(Flight) - ∏ y.distance (σ x.distnance > y.distance (ρ x(∏ distance(Flight)) X ρ y(∏ distance(Flight))) OR using aggregate function:- F_Max(distance)(Flight)

for minimum

∏ distance(Flight) - ∏ x.distance (σ x.distnance > y.distance (ρ x(∏ distance(Flight)) X ρ y(∏ distance(Flight)))  OR using aggregate function:- F_MIN(distance)(Flight)

for average F_AVG(distance) (Flight)

3.∏Passenger.passengerNo ,Passenger.name(σ Flight.arrival="Houston"(Passenger |X| Flight |X| Booking))