With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
There's a SQL database for a pretend movie rental company.
It has these 2 tables:
1. "movies" - this table has a column titled "num_rentals"
2. "customer_rentals" - this table has a column titled "item_rental_id"
The company wants to keep track of how many times a movie has been rented in the "num_rentals" column that resides in the "movie" table.
Must create an INSERT, UPDATE and DELETE trigger that will automatically add, subtract, or both add/subtract values in the "num_rentals" column every time a new entry is made into the "item_rental_id", which represents that a movie has been rented, and so it must be accounted for in the "num_rentals" column. If a "item_rental_id" is deleted, then the value in the "num_rentals" column must be subtracted.
I have the actual database that you can login to and see. It's a fairly simple task but I am really new at this and can't figure it out.
MUST BE DONE TODAY....
Sign in or Register to see more