As a System Admin, I need to be able to schedule a trailer for a given movie title.

max-elixir / MovieManager

Movie Manager is a web and/or android-based application that assists movie theater staff in maintaining and building a movie schedule. Group project for a Database Systems class.

0 stars 0 forks source link

As a System Admin, I need to be able to schedule a trailer for a given movie title. #14

Open sftwre opened 5 years ago

sftwre commented 5 years ago

Input is trailer name, screenId, and start_time. Output is the updated trailer_schedule for the movie.

Trailer
Trailer_schedule

If the given time slot is already occupied by another trailer, the user should see an error.
If trailer name is invalid, throw an exception.
If screen id is invalid, throw an exception.
If the start_time is past the start time of the movie, an exception should be thrown.

example query: schedule_trailer('Spiderman', 'Avengers', 1, '9:35 AM');