From Database Systems The Complete Book Volume 2

318 CHAPTER 7. CONSTRAINTS AND TRIGG 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. Movies (title, year , length, genre, studioName, StarsIn (movieTitle, movieYear, starName) MovieStar (name, address, gender, birthdate) MovieExec(name, address, cert#, netWorth) Studio (name, address, pres ) producerC#) Declare the following referential integrity constraints for the movie database as in 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