The test I run on your account is:

select * from H3_Enrol
where StudentID = 100;

begin
   dbms_output.put_line(ConvertToGradePoint('A'));
   dbms_output.put_line(ConvertToGradePoint('A-'));
   dbms_output.put_line(ConvertToGradePoint('B+'));
   dbms_output.put_line(ConvertToGradePoint('B'));
   dbms_output.put_line(ConvertToGradePoint('B-'));
   dbms_output.put_line(ConvertToGradePoint('C+'));
   dbms_output.put_line(ConvertToGradePoint('C'));
   dbms_output.put_line(ConvertToGradePoint('C-'));
   dbms_output.put_line(ConvertToGradePoint('D+'));
   dbms_output.put_line(ConvertToGradePoint('D'));
   dbms_output.put_line(ConvertToGradePoint('D-'));
   dbms_output.put_line(ConvertToGradePoint('F'));
end;
/

insert into H3_Raw_Enrol (EnrolID, StudentID, CourseID, Score)
values (205, 100, 108, 85);

select * from H3_Students
where StudentID = 100;

insert into H3_Raw_Enrol (EnrolID, StudentID, CourseID)
values (206, 100, 107);

select * from H3_Students
where StudentID = 100;

insert into H3_Raw_Enrol (EnrolID, StudentID, CourseID, Score)
values (207, 100, 106, 95);

select * from H3_Students
where StudentID = 100;

select * from H3_Enrol
where StudentID = 100;

rollback;
 

You should run the test yourself and see the effect.  Change the user name in the code above.

In general, you need to allow me to test run your program:

• Tell me your account name.
• Adhere to the naming convention, don't name ConvertToGradePoint as H3_ConvertToGradePoint, for example.
• Tables and views should be there for me to test.

• Mostly OK.
• Nearly all of you don't having matching Total Credits in H3_Students to that of credits in H3_Enrol.  I have not deducted points from this, though.

• This one is supposed to be simple, but 11 of you have it incorrect.  Testing is always important!!

• Most problematic question.
• If score is null, then you should not update TotalCredit, GPA and TotalGP of the student.
• Most problematic in handling null score.