TIM $50-$ Spring $2024$ Database Assignment $2($Due May $23,2024)$

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.

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.

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

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

What is the maximum number of passengers that can arrive in SFO on an airbus? $($Hint: Airbus aircraft models include $\text{'}3\text{'})$

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