7.1.4 Exercises for Section 7.1 Exercise 7.1.1: Our running example movie database of Section 2.2.8 has keys defined for all its relations. producerC#) Movies(title, year , length, genre, studioName , StarsIn(movieTitle, movieYear, starName) MovieStar (name, address, gender, birthdate) MovieExec(name, address, cert#, netWorth) Studio(name, address, presC Declare the following referential integrity constraints for the movie database as n Exercise 7.1.1 a) The producer of a movie must be someone mentioned in MovieExec. Mod- ifications to MovieExec that violate this constraint are rejected. b) Repeat (a), but violations result in the producer in Movie being set to c) Repeat (a), but violations result in the deletion or update of the offending d) A movie that appears in StarsIn must also appear in Movie. Handle e) A star appearing in StarsIn must also appear in MovieStar. Handle NULL Movie tuple. violations by rejecting the modification. violations by deleting violating tuples