Project 2

** Tasks 1 and 2 are taken screenshots and uploaded:

-- QUESTION 12

CREATE DEFINER=`root`@`localhost` PROCEDURE `collegesdata`()
BEGIN
select ROllNo,LastUpdate,lower(Name)Name,lower(FatherName)FatherName,
lower(MotherName)MotherName,Batch,Degree,PresentStatus,HSDegree,EntranceExam,
Institute,Location from college_a_hs_v;
select ROllNo,LastUpdate,lower(Name)Name,lower(FatherName)FatherName,
lower(MotherName)MotherName,Batch,Degree,PresentStatus,Organization,
Location from college_a_se_v;
select ROllNo,LastUpdate,lower(Name)Name,lower(FatherName)FatherName,
lower(MotherName)MotherName,Batch,Degree,PresentStatus,Organization,Designation,
Location from college_a_sj_v;
select ROllNo,LastUpdate,lower(Name)Name,lower(FatherName)FatherName,
lower(MotherName)MotherName,Branch,Batch,Degree,PresentStatus,HSDegree,EntranceExam,
Institute,Location from college_b_hs_v;
select ROllNo,LastUpdate,lower(Name)Name,lower(FatherName)FatherName,
lower(MotherName)MotherName,Branch,Batch,Degree,PresentStatus,Organization,
Location from college_b_se_v;
select ROllNo,LastUpdate,lower(Name)Name,lower(FatherName)FatherName,
lower(MotherName)MotherName,Branch,Batch,Degree,PresentStatus,Organization,Designation,
 Location from college_b_sj_v;
END