Question: I just need help with #4. If you could help me with the tables and relationships that would be awesome! 48 AM 15-17 Furry Friends
48 AM 15-17 Furry Friends Foundation I (Creating a New Database from Scratch) mal chat etable for adoption. F berpunopeu tioned the guest from a wealthy gentlemi The Funny Trends Foundation Canonprofit organisation that finds homes for abandoned an who lived his life taking care of tray an inbranded to be sure that such animals man looked after once he was gone. Although the amount the foundation started with was sufficient to het up an office and begin operations, it depends upon continuing donations to run daily operations, yearend statements that document their donations to the Foundation for tax purposes. Usually, FFF has not been keeping good records. Over the years, the foundation has had requests for 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 FFE Requirements 1. Using Access or a similar relational database, create the tables needed to set up a database for contributors, contributions, and whether the contributions are to be used for dogs, cats, or nonspecified 2. What did you use for the primary record key of the FFF donation file table? Why did you use it? Using Access or similar software as required by your instructor, add yourself as a contributor. - Create relationships for the tables. Zip First Name FFF Contributor File Contributor ID Last Name 13456 Aggles 13480 Lawrence 13484 Kitty Street Address 1845 Mays Ave 9190 Bentley Road 5815 AIS Lane Go Marie Robert City College Station Waltham Tampa State TX MA FL 77843 02423 53887 FFF Donation File Animal Code Amount Contributor ID D TX Donation Date September 30, 2013 September 20, 2013 October 15, 2013 October 15, 2013 October 31, 2013 October 31, 2013 November 30, 2013 November 15, 2013 December 1, 2013 December 10, 2013 September 10, 2013 FFF Animal Code Table 13456 13456 13456 13456 13456 13456 13456 13456 13456 13480 Contribution for. Code OOOOOOOOOOOOOOOOOO 25 125 25 10 20 20 250 25 70 100 250 500 150 100 100 100 100 50 13480 MA D C H G Dogs Cats Hamster Guinea Pig Rabbit Other October 10, 2013 November 11, 2013 December 14, 2013 September 5, 2013 October 10, 2013 Novober 8, 2013 December 15, 2013 D 13480 13480 13484 13484 13484 13484 13484 IOCCO 'FL
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
