Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 CIDRStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started