Task 1:
Write the SQL on jupyter notebook to create a table, then update the name of one of its columns and add a couple of records. Briefly explain the use of the table you created; what does need to be processed and output with this data?. Post the input and output of the SQL commands using a screenshot from your Jupyter notebook session.
Make sure your original post is unique,I would like you to consider a table that will be part of a process you are passionate about or work with. This table will be carried on into task 2, so you will have time to make it perfect and possibly create other tables to join with this one as well, or fine-tune this one through the process of normalization.
You need this when using Jupiter notebook:
import mysql.connector
mydb = mysql.connector.connect(
host="mysql", database='ALY2100', user="ALY2100", password="homework"
attaching screenshots of examples for task 1 (dont use the examples)
Task 2:
Expand your task 1 by revising the table you created and giving a better explanation of its goals. Are there any other data points (columns/variables) that need to be added? Is there any other table you need to create? Consider normalization techniques and create at least one more table to be joined; Add more records, update at least one record, create counts, sum, and average, delete one or two records, in summary, apply all the statements you learned plus what you have learned up to now (need to have a user-defined function at minimum, loop, if/else). Make sure to use try/exception to avoid code-breaking.
Create a flow chart where the tables are used and illustrate the necessary commands.
MUST write a user interface where you ask a user if he/she wants to insert, update or delete info, and then execute the actions accordingly. make sure to show some stats to the user.
Submit your explanation, the flowchart, and the python code (ipynb).