Design a relational database schema to support a flight tracking application, including tables for flights, airports, and pilots.
