CSE 50 - FALL 2020 Database Assignment 2 (Due Dec 3) For this assignment, download the provided CSV files from Canvas and import them to your Jupyter notebook. Follow the setup steps including creating a database engine, establishing a connection and creating a cursor.

1) Create a table named flights using the data in the flights-2.csv file. Similarly, create a table named aircrafts using the data in the aircrafts.csv file. Investigate that the tables have been created and data has been inserted correctly.

2) Generate a report showing the total number of seats for all flights arriving in SFO from LHR.

3) What is the aircraft that has the maximum number of seats that can arrive in SFO from London (LHR) or Frankfurt (FRA)?

4) What is the maximum number of passengers that can arrive in SFO on an airbus? (Hint: Airbus aircraft models include 3)

5) What is the number of flights each aircraft type has from LAX to SFO?