Task 2 [12 marks]
Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place the package specification (as is) and the package body in your SQL script. The marks for each function and procedure are of equal value (3 marks).
create or replace package assignment3
is
procedure open_class(Class_Info in Tut_Prac%ROWTYPE);
procedure enrol_student(SID in enrol.StudentID%TYPE, CID in enrol.ClassID%TYPE);
function compute_wam(SID in AcademicRec.StudentID%TYPE) return number;
procedure unit_dependencies(CNo in Course_Prerequisite.CourseNo%TYPE);
end assignment3;
/