Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
we've used check to enforce constraints on table movies and StarIn. However, some constraints can be enforced by using Triggers. Please create...
we've used check to enforce constraints on table movies and StarIn. However, some constraints can be enforced by using Triggers.
Please create triggers to implement the following constraints.
1) create triggers on the table movies to make sure for any inserted or updated tuple,
• The length cannot be less than 30 minutes or more than 480 minutes
• The year must be 1929 or later
2) Verify your triggers on the DB
