https://drive.google.com/file/d/1roDwV61gZLaB5-UvINAUkpzSNhO3sCoM/view?usp=share_link

link for the data base.

Please take your time on doing this with no rush and please make sure their are no errors regarding the name. You can open the link and import the data in the mysql

1. Provide a query that will make a view for task 8 from Lab 9.
2. Provide a query that would make an index that would improve the performance of searches against the elevation field.
3. Provide a query that would make an index that would improve the performance of searches against both the source and destination airport field.
4. How many rows are in the countries table. Provide the actual number
5. Open a second connection to your local MySQL server.
6. Start a transaction in the first connection and insert a row in the countries table.
7. In the first connection, how many rows are in the countries table now?
8. In the second connection, how many rows are reported in the countries table?
9. Commit the transaction in the first connection.
10. In the second connection, how many rows are reported in the countries table?
11. Again, start a transaction in the first connection.
12. Delete the row you just added.
13. In the first connection, how many rows are in the countries table now?
14. In the second connection, how many rows are reported in the countries table?
15. Commit the transaction in the first connection.
16. In the second connection, how many rows are reported in the countries table?