Ssn and final score which will change the final score


For the following grade database:
Student(ssn, name, section,HW1,HW2,Midterm, Final,)
Develop PL/SQL to:
a) Get the score for each student, print 'pass' score above 60, 'fail' otherwise.
b) Get average score for each section.
c) Write a procedure which take SSN and final score which will change the final score of the student, write the old and new scores.
d) Write a trigger which will not allow inserting or updating of section if the section number not between 1 and 5.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Ssn and final score which will change the final score
Reference No:- TGS057823

Expected delivery within 24 Hours