Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a stored procedure in database CSE581labs. Execute it. Deliverables: Multiple screenshots, as described through the lab. Scripts that you used to carry out the
Create a stored procedure in database CSE581labs. Execute it. Deliverables: Multiple screenshots, as described through the lab. Scripts that you used to carry out the actions. Steps: 1. Create a stored procedure. Input for the stored procedure will be Course Id and Student Id. The stored procedure will check if the student is enrolled in the class yet. a) If the student has already been enrolled, display a message that says "The student is already enrolled". b) If the student has not been enrolled yet, and the course doesn't have a faculty yet, display a message that says "Cannot enroll until faculty is selected". c) If the student has not been enrolled yet, and the course does have a faculty assigned, then enroll the student in the course and display a message that says "Student enrolled". Provide a screenshot of script execution that creates the stored procedure. 2. Select from the Enrollment table, to see data prior to execution. Provide a screenshot. 3. Run the stored procedure to prove that all 3 cases work. For each case, provide a screenshot of script execution and screenshots of Enrollment and Courses table after execution.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started