Q: write stored procedure queries about the mention scenario.

Thanks

Show transcribed image textView comments (2)

Expert Answer

An expert answer will be posted here

Up next for you in Computer Science

Question 3 An ISP is granted a block of addresses starting with 129.80.0.0/16. The ISP wants to distribute these blocks to 2600 group

Question-4 TOPIC: SQL Stored procedures: S ID Name Gender City 101 201 301 401 501 601 Ella F Christian M Sofia F Lillian F John M Joseph M California Texas Arizona Maryland California Hawaii Attendance Quiz Quiz Quiz Assign Assign Assign Final % 1 2 3 1 2 3 (10) (10) (10) (10) (15) (10) (45) 69 5 8 6 5 12 7 34 88 6 7 7 5 11 6 43 68 5 2 5 8 10 3 26 82 6 3 4 5 9 7 34 60 7 5 8 9 8 6 41 72 8 6 0 5 14 4 22 T_ID 1101 1102 1103 1104 CourseName Digital marketing AI and data science Web development Cyber Security SID 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 A 4 81-87 B B+ 3.5 74-80 B 3 67-73 C+ 2.5 60-66 2 Below 60 Id F Question-4 TOPIC: SQL Stored procedures: S ID Name Gender City 101 201 301 401 501 601 Ella F Christian M Sofia F Lillian F John M Joseph M California Texas Arizona Maryland California Hawaii Attendance Quiz Quiz Quiz Assign Assign Assign Final % 1 2 3 1 2 3 (10) (10) (10) (10) (15) (10) (45) 69 5 8 6 5 12 7 34 88 6 7 7 5 11 6 43 68 5 2 5 8 10 3 26 82 6 3 4 5 9 7 34 60 7 5 8 9 8 6 41 72 8 6 0 5 14 4 22 T_ID 1101 1102 1103 1104 CourseName Digital marketing AI and data science Web development Cyber Security SID 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 A 4 81-87 B B+ 3.5 74-80 B 3 67-73 C+ 2.5 60-66 2 Below 60 Id F