*CREATE A RELATIONAL DATABASE MODEL WITH THIS INFORMATION*

Reliable Airlines Database Flt Pass Pass Pilot Pilot FName LName Aircraft Tail Type Date 9/30/2017W 9/30/2017W 9/30/2017 O 10/1/2017 O 9/30/2017 O 9/30/2017 C. 9/30/2017 C. 9/30/2017 C. Num Origin Dest Num FNameL Name Wright Wright Wright Wright Wright Lindbergh B757 Lindbergh B757 Lindbergh B757 CJ-300 N859 ATL MGM 1614 Sam Snead EtheridgePP Etheridge PP Blank Ditka Blank EtheridgePP Ford DL CJ-300 N611 MGM ATL 1615 Carol 8757 B757 N342 ATL N342 ATL L-1011 N254 NYC N342 NYC N342 NYC N342 NYC NYC1750Carol NYC1750Arthur ATL 1751Mike DL 1201 Arthur FPG1201Carol FPG 1201 Nelson Using the Reliable Airlines flat file that shows five airline trips, above, construct a relational database of tables to manage this data. The data includes dates, pilot's first name, pilot's last name, type of aircraft, the aircraft tail-number (unique to each aircraft and assigned by the FAA), the origin airport, the destination airport (FPG is Paris), the flight number, passenger's first name, passenger's last name, and what the passenger used for positive identification (among the acceptable forms of ID by the TSA) when checking in for the first leg of their trip (assume DL = driver's license and PP = passport)