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
-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
Answers
There are no human answers yet.
Answered by
GPT 3.5
1. π No.plane, name(plane) (σ capacity > 350 (plane))
2. π number, name, addr, D-room(pilot)
2. π number, name, addr, D-room(pilot)
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.