MYSQL ASAP DATABASW

I NEED HELP WITH QUESTION E, IF YOU CAN COMPLETE ALL PLEASE DO AL, BUT I MAINLY NEED ESTIONS

Exercise 7.5.4: Write the following as triggers. In each case, disallow or undo the modification if it does not satisfy the stated constraint. The problems are based on our running movie example Movies (title, year, length, genre, studioName , StarsIn(movieTitle, movieYear, starName) MovieStar (name, address, gender, birthdate) MovieExec(name, address, cert#, netWorth) Studio (name, address, presC#) producerC#) You may assume that the desired condition holds before any change to the database is attempted. Also, prefer to modify the database, even if it means inserting tuples with NULL or default values, rather than rejecting the attempted modification a) Assure that at all times, any star appearing in StarsIn also appears in MovieStar b) Assure that at all times every movie executive appears as either a studio president, a producer of a movie, or both c) Assure that every movie has at least one male and one female star 7.6. SUMMARY OF CHAPTER 7 339 d) Assure that the number of movies made by any studio in any year is no more than 100. e) Assure that the average length of all movies made in any year is no more than 120