Answered You can hire a professional tutor to get the answer.

QUESTION

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...

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.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question