Project 2

Project 2 - Alumni Record of College A and College B

• Create database
• Import the data
• Desc command
• Display the tables in python (by importing mysql.connector)
• Import the data into Excel (using Mysql for Excel add-in)
• Data cleaning -> create view without null values
• Creating procedure
• Pivot chart for location of alumni
• The percentage of career choice of College A and College B Alumni