Project 2

Q1)

CREATE DATABASE alumni;

Q2)

imported all csv files into database alumni

SHOW TABLES;

Q3)

College_A_HS

DESC college_a_hs;

College_A_SE

DESC college_a_se;

College_A_SJ

DESC college_a_sj;

College_B_HS

DESC college_b_hs;

College_B_SE

DESC college_b_se;

College_B_SJ

DESC college_b_sj;

Q4)

College_A_HS

College_A_SE

College_A_SJ

College_B_HS

College_B_SE

College_B_SJ

Q5)

College_A_HS

College_A_SE

College_A_SJ

College_B_HS

College_B_SE

College_B_SJ

Q6)

College_A_HS_V

Q7)

College_A_SE_V

Q8)

College_A_SJ_V

Q9)

College_B_HS_V

Q10)

College_B_SE_V

Q11)

College_B_SJ_V

Q12)

created procedure convertintosmall

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

Q13)

Q14)

Q15)

Q16)