Aircraft_Models Airlines Fleet MID manufacturer model capacity AID AID MID name count 1 777 340 AA Вoeing Boeing Вoeing Airbus 1 1 3 15 2 787 260 2 UAL 1 2 10 3 737 140 3 DAL 2 14 320 380 4 230 4 SWA...

. a) Write an SQL query to find the manufacturer and model for all aircraft models with capacity at least 300.

   b) write a relational algebra expression which is equivalent to the above query.

   c)  Write an SQL query to find the names of the airlines that have at least 10 Boeing 737 in their fleet.

   d) What is the result of the
natural join
of the following two tables:
Airlines
and
Fleet

Extracted text: Aircraft_Models Airlines Fleet MID manufacturer model capacity AID AID MID name count 1 777 340 AA Вoeing Boeing Вoeing Airbus 1 1 3 15 2 787 260 2 UAL 1 2 10 3 737 140 3 DAL 2 14 320 380 4 230 4 SWA 3 1 8 5 Airbus 560 5 ASA 3 24 Вoeing 747 420 4 3 7 5 3 16