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

OR
OR

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.