Project 2

1. Create new schema as alumni

create database alumini;
show databases;

• Import all .csv files into MySQL

Rightclick alumini-table data import wizard-select path-next-next-finish

Run SQL command to see the structure of six tables

describe alumini.college_a_hs;

describe alumini.college_a_se;

describe alumini.college_a_sj;

describe alumini.college_b_hs;

describe alumini.college_b_se;

describe alumini.college_b_sj;

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

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 1500 rows

remaining all are subimitied as files