Question
This question is from my database class; using SQL In this part we create a small procedure: Write a procedure that has as input the
This question is from my database class;
using SQL
In this part we create a small procedure:
Write a procedure that has as input the customer_id. Then the procedure should delete the corresponding customer from table customers.
Notice that customer_id is a foreign key on table orders. Therefore the customer cannot be deleted if he has placed orders. To delete a record from customers you should first delete the corresponding orders and to do that you need to first delete the corresponding order_details.
Now execute the procedure to delete customer with id 1. If you have solved part 01 a record will be inserted into Customer_Archives.
ROLLBACK; and all these changes will be undone!
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