View the step-by-step solution to:

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.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question