Project 2

1. create a new schema alumni

2. imported 6 tables of csv file into mysql

3 . table a_hs

table a_se

table a_sj

table b_hs

table b_se

table b_sj

4 . a_hs

a_se

a_sj

b_hs

b_se

b_sj

6. COLLEGE_A_HS_V

7.COLLEGE_A_SE_V

8.COLLEGE_A_SJ_V

9.COLLEGE_B_HS_V

10.COLLEGE_B_SE_V

11.COLLEGE_B_SJ

12. lower case

college_a_hs

college_a_se

college_a_sj

college_b_hs

college_b_se

college_b_sj

14. CURSOR for total student names in college A

15 . CURSOR for total student names in college B

16 . SUBMITTED IN WORKSHEET

QUESTION 5 , 13 is not answered because of technical of issue of excell not connecting to mysql