Project 2

Q3.RUN SQL COMMAND TO SEE THE STRUCTURE OF SIX TABLES.

Q4.Display first 1000 rows of tables College_A_HS

Display first 1000 rows of tables College_A_SE

Display first 1000 rows of tables College_A_SJ

Display first 1000 rows of tables College_B_HS

Display first 1000 rows of tables College_B_SE

Display first 1000 rows of tables College_B_SJ

Q5.

Import all the records of tables College_A_HS

Import all the records of tables College_A_SE

Import all the records of tables College_A_SJ

Import all the records of tables College_B_HS

Import all the records of tables College_B_SE

Import all the records of tables College_B_SJ

Q6.Perform data cleaning on table College_A_HS and store cleaned data in view College_A_HS_V, Remove null values.

Q7.Perform data cleaning on table College_A_SE and store cleaned data in view College_A_SE_V, Remove null values.

Q8.Perform data cleaning on table College_A_SJ and store cleaned data in view College_A_SJ_V, Remove null values.

Q9.Perform data cleaning on table College_B_HS and store cleaned data in view College_B_HS_V, Remove null values.

Q10.Perform data cleaning on table College_B_SE and store cleaned data in view College_B_SE_V, Remove null values.

Q11.Perform data cleaning on table College_B_SJ and store cleaned data in view College_B_SJ_V, Remove null values.

Q12.Make procedure to use string function/s for converting record of Name, FatherName, MotherName into lower case for 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)

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

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

Q14.Write a query to create procedure get_name_collegeA using the cursor to fetch names of all students from college A.