If antone can help, I would greatly appreciate it. I am struggling to pass this course, and need close to perfect scores just to pass. I wish I had found this site sooner for help, but am trying to do whatever I can just to pass right now. Thank you.
4-21. Furry Friends Foundation I (Creating a New Database from Scratch)
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- Last First Street Phone
butor ID Name Name Address City State Zip Number
13456 Smythe Jonathan 1845 Backpack Lane Franktown NV 55655 501 666–1234
13480 Lawrence Marie 9190 Teepee Road Doolittle NV 54984 501 767–1114
13484 Funky Robert 5815 Pearly Gate Lane Happiness NV 53887 502 995–7654
FFF Donation File
Donation Date Animal Code Amount Contributor ID
September 30, 2009 C 25 13456
September 20, 2009 D 125 13456
October 15, 2009 C 25 13456
October 15, 2009 D 10 13456
October 31, 2009 C 20 13456
October 31, 2009 D 20 13456
November 30, 2009 D 250 13456
November 15, 2009 C 25 13456
December 1, 2009 O 70 13456
December 10, 2009 C 100 13480
September 10, 2009 C 250 13480
October 10, 2009 C 500 13480
November 11, 2009 C 150 13480
December 14, 2009 D 100 13484
September 5, 2009 C 100 13484
October 10, 2009 O 100 13484
November 8, 2009 O 100 13484
December 15, 2009 D 50 13484
FFF Animal Code Table
Contribution for Code
Dogs D
Cats C
Hamster H
Guinea Pig G
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.UsingAccessor 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.
WhatsApp us