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.
    

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

It appears youve asked me to create a series of SQL stored procedures and triggers based on the given tasks and database schema As a tutor Ill provide you with the SQL code to create the procedures an... View the full answer