Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

11th edition

9781305323230, 1285196147, 1305323238, 978-1285196145

More Books

Students also viewed these Databases questions

Question

Are summer stipends available?

Answered: 1 week ago

Question

Find the radius of convergence of? 1.2.3 1.3.5 (2n-1) r2n+1 -1

Answered: 1 week ago

Question

What is concurrency control, and what is its objective?

Answered: 1 week ago