Project 2

Project on Analyzing data of Alumni's record of 2 College.

1.Created a new schema as alumni.

2. Importing 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.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

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.Importing 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.

For college_a_hs

For college_a_se

For college_a_sj

For college_b_hs

For college_b_se

For college_b_sj

6.Performing data cleaning on table college_a_hs and storing cleaned data in view college_a_hs_v, Removing null values.

7.Performing data cleaning on table college_a_se and storing cleaned data in view college_a_se_v, Removing null values.

8.Performing data cleaning on table college_a_sj and storing cleaned data in view college_a_sj_v, Removing null values.

9.Performing data cleaning on table college_b_hs and storing cleaned data in view college_b_hs_v, Removing null values

10.Performing data cleaning on table college_b_se and storing cleaned data in view college_b_se_v, Removing null values.

11.Performing data cleaning on table college_b_sj and storing cleaned data in view college_b_sj_v, Removing null values.

12.Making 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)

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

14. Creating a procedure get_name_collegeA using the cursor to fetch names of all students from college A.

15. Create a procedure get_name_collegeB using the cursor to fetch names of all students from college B.

16. Calculating the percentage of career choice of College A and College B Alumni.