The Furry Friends Foundation is a non-profit organization that finds homes for abandoned animals that are suitable for adoption. FFF began operations with a bequest from a wealthy gentleman who lived his life taking care of stray animals and wanted to be sure that such animals were looked after once he was gone. Although the amount the foundation started with was sufficient to set up an office and begin operations, it depends upon continuing donations to run daily operations. FFF has been keeping its records on 4 x 6 cards. Over the years, the foundation has had requests from contributors for year-end statements that document their donations to the Foundation for tax purposes. (Usually, donations are given with a particular type of animal in mind'for example, ‘‘for dogs.'') Now that the number of contributors exceeds 500, the president has decided to develop a database to handle the foundation's accounting and reporting needs. The following is a sample of some of the records at FFF.

Requirements
1. Using Access or a similar relational database, create the tables needed to set up a database for contributors, contributions, and animals.
2. What data field did you use for the primary record key of the FFF contributor table? Why did you use it?
3. Using Access or similar software as required by your instructor, add yourself as a contributor.
4. Create relationships for the tables.
5. Document your work by printing hard copies of each table in datasheet view and the relationships report that shows how they arerelated.

Transcribed Image Text:

FFF Contributor File First Natne Street Address Phone Nutmber butor ID State Zip 13456 Smythe Joathan 1845 Backpack Lane Fraktw NV 55655 50 666-1234 NV 54984 501 767-1114 Rober 5815 Pearly Gate Lahe Happiness NV 53887 502 995-7654 13480 Lawrence Marie 9190 Teepee Road Doolittle Animal CodeAmount Cohtributor ID FFF Animal Code Table Contribution for Code Guinea Pig 13480 13484 13484