Question-4 Marks [10] TOPIC: SQL Stored procedures: SLID Name Gender City 101 201 301 401 501 601 Christian Sofia F Lillian John X Joseph X California Texas Arizona Maryland California Hawaii Attendance Quiz Quiz Quiz AssignLAssige Assige Final 90 1 2 1 2 3 (10) (10) (10) (10) (15) (10) (45) 5 6 12 7 88 3 11 3 45 015 10 3 6 5 U 7 60 7 9 8 61 41 8 6 4 2 T_ID 1101 1102 1103 1104 CourseName Digital marketing AI and data science Web development Cyber Security SLID 101 301 401 201 CASE: The above tables are extracted an examination department of an institution. The examination department wants to have a consolidated total of students' scores in each subject, where, the weightage of quizzes, assignments and attendance are 25%, 35% and 5% respectively The remaining weightage belongs to the final term result. Also, they requested the IT department for a procedure which generates Letter Grades and respective Grade Points (as mentioned in the table below). As the institution has many campuses over the country, they also need to have a City- wise students' progress for campus-wise comparison Marks Grade Points 88-100 4 81-87 B+ 3.5 B 3 74-80 67-73 C+ 2.5 60-66 2 Below 60 F 0 Question-4 Marks [10] TOPIC: SQL Stored procedures: SLID Name Gender City 101 201 301 401 501 601 Christian Sofia F Lillian John X Joseph X California Texas Arizona Maryland California Hawaii Attendance Quiz Quiz Quiz AssignLAssige Assige Final 90 1 2 1 2 3 (10) (10) (10) (10) (15) (10) (45) 5 6 12 7 88 3 11 3 45 015 10 3 6 5 U 7 60 7 9 8 61 41 8 6 4 2 T_ID 1101 1102 1103 1104 CourseName Digital marketing AI and data science Web development Cyber Security SLID 101 301 401 201 CASE: The above tables are extracted an examination department of an institution. The examination department wants to have a consolidated total of students' scores in each subject, where, the weightage of quizzes, assignments and attendance are 25%, 35% and 5% respectively The remaining weightage belongs to the final term result. Also, they requested the IT department for a procedure which generates Letter Grades and respective Grade Points (as mentioned in the table below). As the institution has many campuses over the country, they also need to have a City- wise students' progress for campus-wise comparison Marks Grade Points 88-100 4 81-87 B+ 3.5 B 3 74-80 67-73 C+ 2.5 60-66 2 Below 60 F 0