For this project, you must create the Student database (script provided in the Course Resources).

You need to a package named ENROLL_PACK with the following objects (a procedure and a function) inside.

Procedure named Enroll_By_Course:

· This procedure will display courses, sections in each course, and the enrollment in each section.

· Enter your comments (each section must have a comment) in the program

· The user will enter 0, 1, 2, 3, or 4, which is the level of the course. (For example: courses 420, 430, 450 are 4-level course, courses 10, 20, 25, 80 are 0-level courses).

· The level of the course is the input parameter to the procedure.

· Use a nested cursor. The parent cursor (or outer cursor) calls information about each section of a course for the course level entered. The child cursor (or inner cursor) counts the enrollment for that section.

· Display a header for the Course level entered.

· Display a line for each course with the Course Name and Section Number and the total enrollment.

Function named Student_Enroll:

· Enter your comments (each section must have a comment) in the program

· This function will display how many sections the students are enrolled for.

· Include student's ID and name in each line message.

· If the total number of sections is 3 or more, return a message saying this is too many.

· If the total number of sections is 1 or 2, return a message saying this is fine.

· If the student is not taking any classes, return a message saying the student should enroll for some courses.

· To test the function, use it in a SELECT statement for students with the registration date in between Feb 11 and 13 (inclusive). Use appropriate column headings.