ou will need to submit a Python program for each scenario $($scenario$\_1.$py$,$ scenario$\_2.$py$,$ etc.$).$

Your program should:

$1.$ Connect to the MySQL database using mysql$-$connector$-$python.

$2.$ Execute SQL queries using the cursor.execute$()$ method.

$3.$ Fetch and process the results $($e$.$g$.,$ storing them in variables or lists$).$

$4.$ Provide recommendations based on the data retrieved from the database.

Scenario $1$: Budget Optimization in School Districts

Problem Statement:

A school district is struggling with budget constraints and wants to ensure that it is allocating

salaries effectively without compromising the quality of education.

Tasks:

$1.$ Analyze salary distribution: Identify districts with the highest and lowest average teacher

salaries.

$2.$ Experience vs$.$ Salary: Investigate whether there is a relationship between teacher salaries

and years of experience across different districts No regression models $$ just exploratory

data analysis using SQL commands$).$

Hint: SQL Command: Use AVG$(),$ GROUP BY$,$ and ORDER BY to group data by experience

and calculate average salaries.

$3.$ Recommendations: Based on your analysis, provide recommendations for salary

adjustments that can help the district manage its budget more effectively.