SQL Movie-Rating View Modification Exercises[
-- Question 1
-- Write an instead-of trigger that enables updates to the title attribute of view LateRating.
-- Policy: Updates to attribute title in LateRating should update Movie.title for the corresponding movie. (You may assume attribute mID is a key for table Movie.) Make sure the mID attribute of view LateRating has not also been updated -- if it has been updated, don't make any changes. Don't worry about updates to stars or ratingDate.
-- 

-- Question 2
-- Write an instead-of trigger that enables updates to the stars attribute of view LateRating.
-- Policy: Updates to attribute stars in LateRating should update Rating.stars for the corresponding movie rating. (You may assume attributes [mID,ratingDate] together are a key for table Rating.) Make sure the mID and ratingDate attributes of view LateRating have not also been updated -- if either one has been updated, don't make any changes. Don't worry about updates to title.
-- 

Authorization Quiz

   UPDATE T

   SET a=1, b=2

   WHERE a <= ALL (SELECT d FROM R)

   OR EXISTS (SELECT * FROM S WHERE f > T.a)

  1. User A: grant update on T to B,C with grant option

  2. User B: grant update on T to D with grant option

  3. User C: grant update on T to D with grant option

  4. User D: grant update on T to E

  5. User A: revoke update on T from C cascade