Recall from Case 421 in Chapter 4 that the Furry Friends Foundation is a nonprofit organization that finds homes for abandoned animals. The foundation has recently computerized some of its operations by storing its accounting data in a relational database. One reason for this was to enable it to more easily answer questions about donations. This portion of the case provides some examples of such questions and gives you practice creating database queries to answer them.
1. If you have not already done so, create the tables and relationships described in Case 421.
2. Using Access or similar software as required by your instructor, create three donations for yourself. You should donate to dogs in one contribution, cats in the second contribution, and unspecified (?~?~other) in the third contribution.
3. Create a query that selects all customers donating to cats. Print your results.
4. Create a query that selects all contributors who donated over $50. Print your results.
5. Create a query that selects all contributors who donated over $100 to dogs. Print your results.