Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Create 3 Simple SQL Triggers
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.


Job awarded.

Jul 29, 2012

Job Description

  |  Change History >>


  • Posted: Sun, Jul 29, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: $50 or less
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

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.


Sign in or Register to see more

Job ID: 32334300
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
Hi! If you are seeking a dependable virtual assistant who gives organized, timely and accurate results, then I request your attention! I am a...
 0.0   |  Private   |  0 Jobs
Bid ID: 32334625  |  Submitted: Jul 29, 2012 20:13 ET 
Within 1 day
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »