Hello! I'm going to attach the PDF that gives everything you need for this assignment. Here's a preview of what needs to be done:PROBLEM STATEMENT: We want to simulate a simple ATM machine. An account holder should be able to sign in and see a menu of transactions: get balance, withdraw, deposit, or quit. The ATM should properly and regularly communicate with the user. The ATM should get information on existing users and accounts from a file. An accounts.txt file is posted together with this assignment. You should look carefully at the structure of each line of the file, which contains a 4 digit secret code, first and last name of users, and the current balance.

Option #1: Integrating MySQL Table Data with a Python ScriptIn this assignment, you will write a Python script to increase the population of each city in the world_x database by 10% (rounded).First, add a new column to the world_x city table using the following MySQL command:ALTER TABLE `world_x`.`city` ADD COLUMN `Population` DOUBLE NULL DEFAULT NULL AFTER `Info`;The existing population data are stored as JSON datatype in the city table in a field named Info. You learned about JSON data types in Module 2. To obtain the population data from the Info column in the city table, run the following MySQL command:select info->’$.Population’ from cityYour Python script should do the following:Copy the population data from the Info column into the Population column,Increase the population by 10% in the Population column, andList the population before the increase and the population after it was increased.Submit your Python script and Python script output as two separate text files included in a zip file. Submit your zip file to the Module 6 folder. Provide a detailed technical report on the steps needed to integrate Python and MySQL. In addition, provide details on how you iterate through a JSON field in a Python script.