module 6 critical thinking its 410
![](https://superbprofessors.com/wp-content/uploads/2020/04/header-banner-1400x400-1.jpg)
Choose one of the following two assignments to complete this week. Do not do both assignments. Identify your assignment choice in the title of your submission.
Option #1: Integrating MySQL Table Data with a Python Script
In 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 city
Your 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, and
List 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.
Option #2: Integrating MySQL Table Data with a Python Script
Using the classicmodels database you installed in Module 1, write a Python script that deducts one percent from the amounts paid for purchases made in the month of December. The amounts customers paid are listed in the payments table. The output of your script should show the payments before the rebate and the payments after the rebate.
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 implement a table join in a Python script. Show an example of such a join.
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code “Newclient” for a 15% Discount!NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
The post module 6 critical thinking its 410 appeared first on Superb Professors.