So Imma build an API.

• Retrive a list of all customers
• Retrive a subset of customers
  • Given a sort column, return n customer records, offset by p records (this will be used to create "pages" of customers)
  • Sort columns are
    • name
    • registered_at
    • postal_code
• Given a customer's id...
  • List the movies they currently have checked out
  • List the movies a customer has checked out in the past
    • ordered by check out date
    • includes return date

• Retrieve a list of all movies
• Retrieve a subset of movies
  • Given a sort column, return n movie records, offset by p records (this will be used to create "pages" of movies)
  • Sort columns are
    • title
    • release_date
• Given a movie's title...
  • Get a list of customers that have currently checked out a copy of the film
  • Get a list of customers that have checked out a copy in the past
    • ordered by customer id
    • ordered by customer name
    • ordered by check out date

• Look a movie up by title to see
  • it's synopsis
  • release date
  • and inventory total
• Know if a movie has any inventory available to rent
• See a list of customers that have currently checked out any of the movie's inventory
• Given a customer's id and a movie's title ...
  • "check out" one of the movie's inventory to the customer
    • Establish a return date
    • Charge the customer's account (cost up to you)
  • "check in" one of customer's rentals
    • return the movie to its inventory
• See a list of customers with overdue movies