QI [1 pt]: using the same Movie schema we discussed in HW #2: Movies(title, year, length, genre, studioName, producerC#) StarsIn(movieTitle, movieYear, starName) MovieStar(name, address, gender, birthdate) MovieExec(name, address, cert#, networth) Studio(name, address, presCs) Declare the following referential integrity constraints for the Movie database: a) The producer of a movie must be someone mentioned in MovieExec. Modification to MovieExec that violate this constraint are rejected? b) Repeat (a), but violations result in the producer# in Movie being set to NULL c) Repeat (a), but violations result in the deletion or update of the offending Movie tuple. d) A movie that appears in StarIn must also appear in Movie. Handle violations by rejecting the modifications