[Solved]Write Following Constraints Tuple Based Check Constraints One Relations Running Movies Exa Q37088874

Write the following constraints as tuple-based CHECK constraintson one of the relations of our running movies example: M o v ies(title , y ea r, len g th , genre, studioName, producerC#) StarsIn (m o v ieT itle, movieYear, starName) MovieStar(name, ad dress, gender, b irth d a te ) MovieExec(name, ad d ress, c e rt# ,netWorth) Studio(name, ad d ress, presC#) If the constraintactually involves two relations, then you should put constraints inboth relations so that whichever relation changes, the constraintwill be checked on insertions and updates. Assume no deletions; itis not always possible to maintain tuple-based constraints in theface of deletions. a) A star may not appear in a movie made beforethey were born. ! b) No two studios may have the same address. ! c)A name that appears in MovieStar must not also appear in MovieExec.! d) A studio name that appears in Studio must also appear in atleast one

Expert Answer

---

Answer to Write the following constraints as tuple-based CHECK constraints on one of the relations of our running movies example: … . . .