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
- Write a confidence interval problem using one of the options below. For whichever option you choose, gather the appropriate data and post your problem (without
- You are standing at a fixed point on the ground. A drone is flying at constant height of 40 meters above the ground and is traveling at a constant speed of 8
- For your initial post, choose one of the following two prompts to respond to. Then in your two follow up posts, respond at least once in each option. Use the