Using Relations Already Provided Namely Student Module Marks Write Following Stored Proced Q43867302
Using the relations already provided to you namely , student,module, marks and write the following stored procedure as input themodule code, the weight for coursework in sql. It will display thegrades for students for a specific module based on total marks.Gradings are as follows:
modules – maths, programming, system design, database
Total Marks >80 = A+
Total marks between 71 and 80= A
Total marks between 61 and 70= B
Total marks between 51 and 60 = C
Total marks less than 50 = F
1.Using Sql display Minimum total marks, average total marks,and maximum total marks for each module
2.Using Sql display the ID of all students who have failed andthe modules they have failed.
Expert Answer
Answer to Using the relations already provided to you namely , student, module, marks and write the following stored procedure as …
OR