Output the message: [student_id] is enrolled in [tot_sec] courses.

For those students not enrolled in any courses, output the message: [student_id] is not enrolled in any courses.

Test your procedure with the following values: 102, 124, 292.

The procedure should accept the Section ID and Course No as parameters.

Include the following for the other columns:

Use USER and CURRENT DATE for the auditing columns (Created By, Created Date, Modified By, Modified Date).

When a record can successfully be inserted, output the message: Section [section_id] of course number [course_no] was inserted.

Use an exception to handle the error when the course parent does not exist; in that case, output the message: The INSERT was not successful.  You must insert the course parent first.

Execute your procedure with the following values:

• section id 77 with course number 10
• section id 78 with course number 400

Create a stored procedure to delete Student records; the student ID should be passed into the procedure as a parameter.

Use an exception handler to trap the errors that arise when the procedure tries to delete a student who is still in the enrollment table.

For successful deletions, output a message which says:

Student id [student_id] has been deleted

For unsuccessful deletions, output a message which says:

The delete was not successful. Delete the student from enrollment first.

Execute the procedure for students 124 and 158.

Create a stored procedure to insert Student records; the student ID should be passed into the procedure as a parameter. Default values can be used to set the other fields in the table.

Use an exception handler to trap the errors that arise when the procedure tries to insert a student with a number that is already in the table.

For successful insertions, output a message which says:

Student id [student_id] has been inserted

For unsuccessful insertions, output a message which says:

Student id [student_id] is already in the table

Execute the procedure using student ids of 110 and 190.