1. Create a stored procedure to Enter all the information for a new donor and donation. For this procedure assume only two contact types home phone and email. Make sure that all the inserts happen or none of them by using transactions and error trapping. Suggestion: plot out all the steps on paper first. Outline what needs to be done in what order.
2. Create a trigger that fires on the insert of a grant. It checks to see if the grant is greater than the maximum grant of 2000 dollars. If the grant is greater it prints out a message
3. Make a new grant entry to test the trigger. (it can be for an existing person.)