Create a SQL procedure

1. Show Agency Name and Contact name and phone.
2. Execute the stored procedure
3. Show maximum donations and total of donations by description.
4. Execute the stored procedure
5. Displays total in donations
6. Execute the stored procedure
7. Adds a new Facility to the facility table
8. Execute the procedure
9. Updates the pickup required field based on donationid
10. Execute the procedure setting pickup required to yes for donationid 2100
11. Adds a new Agency Record and checks to see if the Agency name is already in the database if it is it won’t be added
12. Execute the stored procedure with valid and invalid data
13. Inserts a donation but only if the donor is in the donor table
14. Execute the stored procedure with valid and invalid values
15. Deletes a facility from the facility table
16. Execute the stored procedure

Create a trigger to:

1. Does not allow more than one record deletion at a time from the Agency table
2. Does not allow a donation if there is not donor in the donor table
3. Checks to see if the Agency name is already in the database, if it is the update is not allowed.
    

tblDonor DonortD Title FirstName LastName Phone tblDonation DonationID DonorID Agency D DonationDate DonationDesc DonationValue PickupRequired tbiDonationStorage StoragelD DonationID tblAgency AgengID AgencyName ContactFirstName ContactLastName Address City State Zip Phone tbistorage StoragelD Facility D Location tb Facility Facility D FacilityName