Machine Problem Assignment 8 Solution

Machine Problem Assignment 8 Solution

Create and test the following triggers for the database created in Machine Problem 5.  Each trigger applies to updates as well as inserts.  This is Microsoft SQL Server.

1.      A trigger that insures that the movie cost in the Movie table is at least 20.00 and not greater than 70.00.

2.      A trigger that insures that the due date in the DetailRental table is at least one day after the current date.  The current date can be accessed by the getdate() function.

3.      A trigger that insures that the member balance in the Membership table is not less than -20.00.
Powered by