Question

Express the following in relational algebraic queries
-pilot(number of pilot, name,addr,D-room);
-plane(No.plane, name, location);
- flight (No.flight,city-adr,H-Dep,H-Arr);
1.Give the list of the plane (Number and Name)whose capacity is greater than 350 passengers
2.Give all the list of information about the pilots of the company

Answer 1

1. π No.plane, name(plane) (σ capacity > 350 (plane))

2. π number, name, addr, D-room(pilot)