1. Given the following schema:

Airport (City, Country, NumberOfRunways)

Flight (FlightID, Day, DepartCity, DepartTime, ArrCity, ArrTime, PlaneType)

Plane (PlaneType, NumberOfPassengers)

Write the SQL queries with A. using except operator, or with Not IN operator, then B. covert it to Relational Algebra way. The question is, we want to find out:

The Belgian airport that have only domestic flights.

1. Show this query in SQL using Except or Not IN (pick only one):

Solution:

2. Show this query in Relational Algebra:

Solution: