You must complete the assignment with Oracle. You must run test your work before.

For this assignment, you must create the Student database in oracle/ Live SQL (script provided in the link):

studentTable: drive.google.com/file/d/1fJoITwxmkhD2_L6SALxte80W8Osjntg8/view?usp=sharing

 

studentData: drive.google.com/file/d/1eFtXoE07g6NaqS_cNrjb1twb6eWJzNoQ/view?usp=sharing

 

   

You need to create a package named ENROLL_PACK with the following objects (a procedure and a function) inside. Test your code based on the instructions below. Procedure named Enroll_By_Section: 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 procedure has an input parameter, which is the course level. You will provide the course level when executing the package. The level of the course is a number between 0 and 6 (inclusive), which is the level of the course. (For example, courses 420, 430, 450 are 4-level course, courses 10, 20, 25, 80 are 00-level courses). 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 including your first and last name. See output below. Display a line for each course with the Course Name and Section Number and the total enrollment. See the output below. If the number entered by the user does not have any courses at that level, display a proper message. See the output below. Write an execute statement to run the procedure from the package for the course levels: 0, 2, and 5.