Project 2

1) Created new schema as alumni and Imported all .csv files into MySQL with the help of graphical user interface

3) Run DESC command to see the structure of six tables (in project 2 sql file)

4) Displaying first 1000 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) with Python using Jupyter Notebook (.ipynb file is attached)

5) Imported first 1500 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) into MS Excel.( in file sql_project2_Q5)

6) to 11) Performed data cleaning on tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) and store cleaned data in respective view ( College_A_HS_V, College_A_SE_V, College_A_SJ_V, College_B_HS_V, College_B_SE_V, College_B_SJ_V ) using is not null command (in project 2 sql file)

12) Created separate procedure for each view by using string function/s for converting record of Name, FatherName, MotherName into lower case for views (College_A_HS_V, College_A_SE_V, College_A_SJ_V, College_B_HS_V, College_B_SE_V, College_B_SJ_V) (in project 2 sql file)

13) Imported the created views (College_A_HS_V, College_A_SE_V, College_A_SJ_V, College_B_HS_V, College_B_SE_V, College_B_SJ_V) into MS Excel and representing count of student per location using pivot table (in file sql_project2_Q13)

14) Created procedure get_name_collegeA using the cursor to fetch names of all students from college A

15) Created procedure get_name_collegeB using the cursor to fetch names of all students from college B

16) Calculated the percentage of career choice of College A and College B Alumni