This assignment is based on the movie review database . Three tables, Viewer, Movie, and Rating,
1. Write a procedure to drop a movie. Your procedure would take in a Movie ID. If no reviewer has
reviewed this movie before, simply delete it from the movie table. The deletion command in SQL is:
DELETE FROM table_name
Otherwise, delete all rows in the rating table where this movie was reviewed, then delete the
2. Write a function to compute the number of comedy films a reviewer rated. Your function will
take in a viewer UserID and return the count of movies.
3. Write a trigger to check this constraint when a viewer rates a movie:
“Any reviewer can’t review the same movie twice”
1. You must actually test your PROCECURE, FUNCTION, and TRIGGER in your Oracle Account. Write
your PROCECURE, FUNCTION, and TRIGGER in three files, named a9proc.sql, a9func.sql, and
a9trig.sql, respectively. Upload ALL THREE files through the submission link.
Please Test all the results into QUERY ANALYZER from AQUA DATA STUDIO . I will Upload the 3
Place an order with us. Our skilled and experienced writers will deliver a custom paper which is not plagiarized within the deadline which you will specify.
Note; 6 Hours urgent orders deliver also available.
If you need more clarifications contact our support staff via the live chat for immediate response. Use the order calculator below and get ordering with wishessays.com now!
TRY OUR SERVICES TODAY.[order_calculator]