Description

1. The FLIGHT database, which contains one year of flight information for US airports, is attached. We want to extract the following from this database using GRAPHX library in SPARK:
a: Specify the total number of airports as well as point-to-point routes. b: Specify the longest route and routes over 1000 miles.
c: Specify the airports with the highest number of entry routes and the highest number of exit routes. d: Which airport is considered as the most important hub. e: Identify the 10 most important airports and indicate their importance degree. f: what are 5 flights with most delays from source ANC and how much is their delay.
g: What is the shortest route between SJC and LAS airports and respectively include which airports.