Project 2

ALUMNI SCHEMA:

VIEWS AND PROCEDURES:

FOR QUESTION 4 I UPLOADED ipynb FILE OF PYTHON WORK

FOR Q.NO 5 AND 13 I UPLOADED EXCEL FILE WITHIN THAT PIVOT CHARTS EXISTS

OUTPUT FOR LOWER CASE NAMES OF SIX TABLES:

OUTPUT FOR get_name_collegeA PROCEDURE:

OUTPUT FOR get_name_collegeB PROCEDURE:

OUTPUT FOR ALUMNI CHOICES PERCENTAGES OF COLLEGE A AND B:

KINDLY CHECKOUT ALL OF THE FILES I UPLOADED...

THANK YOU;