Project 2

1.created database as alumni

2. Imported tables find below sql attachment.

3.Find below attachment.

4.Find python attachment

5.Find Excel attchment

6. for 6th question not able to write complete cleaning query in my sql workbench it was hanged.so write it here

some code only able to run in my workbench.full cleaning query shown below.

create view college_a_ha_v as
select RollNo,Name,Batch,Degree,PresentStatus,HSDegree,EntranceExam,
Institute,location from college_a_hs
where length(trim(HSDegree))>0 and HSDegree is not null and HSDegree not like "" and hsdegree not like "..." and
hsdegree not like "---" and
EntranceExam not like '' and EntranceExam not like '.' and EntranceExam not like '-' and
EntranceExam not like '....' and EntranceExam not like '--' and EntranceExam not like '_' and
EntranceExam not like '---' and EntranceExam is not null and EntranceExam not like '..' and EntranceExam not like '--------' and EntranceExam not like '...' and
location not like'' and location not like '---' and location not like '.' and Institute not like '...';

7 to 12 find Sql attachment

13.Find Excel attchment 

14.Find Sql attachment

15. FindSql attachment

16. Find Sql attchment