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 grou

See answer

See more questions for subjects you study

Post a question

Answers from our experts for your tough homework questions

Continue to post

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 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 groups as follows: i. The first group has 200 medium sized businesses; each needs 14 hosts. ii. The second group has 400 small businesses; each needs 6 hosts. iii. The third group has 2000 point-to-point links; each needs 2 hosts. iv. Design the sub-blocks and give the slash notation for each sub-block. Find out how many addresses are still available after these allocations. Page 3 of 5 Rubrics (Scoring Guide) Excellent (10) Good (8) All groups first and All groups first and last subnet defined last subnet defined correctly with subnet with minor mistakes mask and CIDR but with correct subnet mask and CIDR Average (5) Poor (2) More than 2 mistakes Wrong subnets with but with proper incorrect subnet subnet mask and mask and CIDR CIDR 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 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 groups as follows: i. The first group has 200 medium sized businesses; each needs 14 hosts. ii. The second group has 400 small businesses; each needs 6 hosts. iii. The third group has 2000 point-to-point links; each needs 2 hosts. iv. Design the sub-blocks and give the slash notation for each sub-block. Find out how many addresses are still available after these allocations. Page 3 of 5 Rubrics (Scoring Guide) Excellent (10) Good (8) All groups first and All groups first and last subnet defined last subnet defined correctly with subnet with minor mistakes mask and CIDR but with correct subnet mask and CIDR Average (5) Poor (2) More than 2 mistakes Wrong subnets with but with proper incorrect subnet subnet mask and mask and CIDR CIDR