The Furry Friends Foundation is a non-profit organization

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

FFF Contributor File

Contri- butor ID

13456 13480 13484

Last Name

Smythe Lawrence Funky

First Name

Jonathan Marie Robert

Street Address

1845 Backpack Lane 9190 Teepee Road 5815 Pearly Gate Lane

City

Franktown Doolittle Happiness

StateZip

NV55655 NV54984 NV53887

Phone Number

501 666–1234 501 767–1114 502 995–7654

FFF Donation File

Donation Date

September 30, 2009 September 20, 2009 October 15, 2009 October 15, 2009 October 31, 2009 October 31, 2009 November 30, 2009 November 15, 2009 December 1, 2009 December 10, 2009 September 10, 2009 October 10, 2009 November 11, 2009 December 14, 2009 September 5, 2009 October 10, 2009 November 8, 2009 December 15, 2009

Animal CodeAmount

C25 D125 C25 D10 C20 D20 D250 C25 O70 C100 C250 C500 C150 D100 C100 O100 O100 D50

Contributor ID

13456 13456 13456 13456 13456 13456 13456 13456 13456 13480 13480 13480 13480 13484 13484 13484 13484 13484

FFF Animal Code Table

Contribution forCode

Dogs D Cats C Hamster H Guinea PigG Rabbit R Other O

Copyright © 2010 John Wiley & Sons, Inc.146

PART TWO / Databases

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