Project 2

Ans 1 . click on data -> mysql for excel -> enter the password for connection -> create new schema-> in pop up wrie name as alumni - > ok

Ans 2. select data then -> export data into table -> apply.

Ans 3. SELECT * FROM alumni.college_b_sj;
SELECT * FROM alumni.college_b_se;
SELECT * FROM alumni.college_b_hs;
SELECT * FROM alumni.college_a_sj;
SELECT * FROM alumni.college_a_se;
SELECT * FROM alumni.college_a_hs;

Ans 4 . ATTACHED PYTHON FILE

ANS 5 . select table -> Edit my sql -> ok -> delete data after 1500-> commit.

OR SELECT TABLE -> IMPORT -> LIMIT 1500 , ROW START WITH 1.

Ans 6, 7, 8, 9 ,10, 11 is given below

Ans 12.

Ans 13. select view table -> import mysql -> select pivotal table -> apply

table pivotalcllege_a, pivotalcollege_b.