Project 2
1.Create new schema as alumni
2.Import all .csv files into MySQL
3.Run SQL command to see the structure of six tables
For college_a_hs
For college_a_se
For college_a_sj
For college_b_hs
For college_b_se
For college_b_sj
4.Display 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
For college_a_hs
For college_a_se
For college_a_sj
For college_b_hs
For college_b_se
For college_b_sj
5.Import 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.
6.Perform data cleaning on table College_A_HS and store cleaned data in view College_A_HS_V, Remove null values.
7.Perform data cleaning on table College_A_SE and store cleaned data in view College_A_SE_V, Remove null values.
8.Perform data cleaning on table College_A_SJ and store cleaned data in view College_A_SJ_V, Remove null values.
9.Perform data cleaning on table College_B_HS and store cleaned data in view College_B_HS_V, Remove null values
10.Perform data cleaning on table College_B_SE and store cleaned data in view College_B_SE_V, Remove null values.
11.Perform data cleaning on table College_B_SJ and store cleaned data in view College_B_SJ_V, Remove null values.
12.Make procedure to use 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)
For College_A_HS_V
For College_A_SE_V
For college_A_SJ_V
For College_B_HS_V
For College_B_SE_V
For College_B_SJ_V
13.Import 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 make pivot chart for location of Alumni.
For College_A_HS_V
For College_A_SE_V
For College_A_SJ_V
For College_B_HS_V
For College_B_SE_V
For College_B_SJ_V
15.Write a query to create procedure get_name_collegeB using the cursor to fetch names of all students from college B.
16.Calculate the percentage of career choice of College A and College B Alumni (w.r.t Higher Studies, Self Employed and Service/Job)
Note: Approximate percentages are considered for career choices.
- .