Project 2

In this project i explore my self alot.

i enjoyed alot.

and i was use views, cursor,union keyword arithmetic opetors and not null keyword etc.,

2.Import all .csv files into MySQL

i import like this remaining files.

these are the tables.

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.

-- college_a_hs table

-- college_a_se table

-- college_a_sj table

-- college_b_hs table

college_b_se table

college_b_sj table

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. 

-- pivot chart for college_a_hs_v table

-- pivot chart for college_a_se_v table

-- pivot chart for college_a_sj_v table

-- pivot chart for college_b_hs_v table

-- pivot chart for college_b_se_v table

-- pivot chart for college_b_sj_v table

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.

         Thank you