1. Create a stored procedure that takes a countrys name as the input parameter and outputs the...
Fantastic news! We've Found the answer you've been seeking!
Question:
1. Create a stored procedure that takes a country’s name as the input parameter and outputs the details of customers in it (customer_id, first_name, last_name).
2. Create a stored procedure that takes a customer_id and returns that customer’s rental and payment history. (display on screen)
3. Look at the triggers on the film table. Understand each one of them and summarize in a couple of lines what they do.
4. Write a stored procedure that takes in a film_id and outputs useful details – such as category, actors, film_text, etc.
5. Create a stored procedure that creates a list of customers that have a rental_id, but no payment_id. That is, those customers who have not paid.
Related Book For
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris
Posted Date: