Given Table Student Stuid Stuname Module Modname Modid Marks Modid Stuid Year Coursework1 Q43877911
Given below table :
Student(StuID, StuName)
Module(ModName, ModID)
Marks(ModID, StuID, Year, Coursework1, Coursework2, Coursework3,Coursework4, Exam1, Exam2, Total)
To write a procedure in SQL Server with a cursor to display thegrade obtained, module name and student name for each student byadding a weightage to each category of marks.
This procedure takes as input the module code, the weight forcoursework. It will display the grades for students for a specificmodule based on total marks
Example : (Coursework + Coursework2 + Coursework3 +Coursework4)*weightage = TotalB
(Exam1 + Exam2)*(100-weightage) = TotalA
Note : The weightage is also a value to be inserted bythe user
TotalMarks = TotalB + TotalA
Gradings are as follows:
Total marks >80 = A+
Total marks between 70 and 79.9= A
Total marks between 60 and 69.9= B
Total marks between 50 and 59.9= C
Total marks less than 50 = F
Example of output should be like :
John got B in module <module ID>
Expert Answer
Answer to Given below table : Student(StuID, StuName) Module(ModName, ModID) Marks(ModID, StuID, Year, Coursework1, Coursework2, C…
OR