In$-$Class Lab Assignment $($Sec $1)$: Testing MS SQL Stored Procedure Skills $(2\mathrm{.}5\%)$

Objective:

This lab assignment aims to test your skills in creating and working with stored procedures in MS SQL$.$ You will create a database named INClass$3,$ add three tables, insert data into these tables, and then write stored procedures based on the given questions.

$1.$ Use the script given to complete the blow $3$ steps

a$.$ Step $1$: Create Database

b$.$ Step $2$: Create Tables

c$.$ Step $3$: Insert Data

$2.$ Step $4$: Crate Stored Procedures for the below $5$ Questions

a$.$ Create a stored procedure named GetStudentDetails that retrieves all details of students.

b$.$ Create a stored procedure named InsertNewEnrollment that inserts a new enrollment for a student.

c$.$ Create a stored procedure named GetAllEnrollments that retrieves all enrollments.

d$.$ Create a stored procedure named DeleteStudent that deletes a student from the Students table.

e$.$ Create a stored procedure named UpdateEnrollmentGrade that updates the grade for a specific enrollment.

Submission Requirements:

$$ Combine all SQL scripts and screenshots of the output for the $5$ tasks you choose to complete into a single document.

$$ Ensure that each task's script and corresponding output screenshot are clearly labeled.

Grading Criteria:

$$ Correctness of SQL scripts and procedures.

$$ Accuracy of the output.

$$ Completeness of the submission $(5$ tasks completed$).$

$$ Proper formatting and organization of the document.

Good luck, and happy coding!