Question: The following is for a intro to relational database class. Any help would be appreciated, thanks so much! Please complete the two problems listed below,

The following is for a intro to relational database class. Any help would be appreciated, thanks so much!

Please complete the two problems listed below, based on the following description:

You have been asked to build a database for Coply Pets, a pet foster and adoption shelter. The agency is a nonprofit that takes in stray or abandoned pets and places them with foster caregivers until the pet is adopted. Foster caregivers are volunteers, though they must first be screened. The database needs to track all animals in its care, their species, breed, name, and condition. It also needs to track all approved foster caregivers and the animals currently in their care. Foster caregivers are also supposed to turn in monthly reports on the animals in their care. The database also needs to track the adoptions of the animals.

Currently, volunteers come into the shelter and fill out a paper form. After a background check, they are added to a file. Some volunteers complain that they are never contacted again. The shelter staff admits, they tend to go with foster caregivers they know, and some people get forgotten in the file. The shelter has also occasionally lost track of an animal in foster care when the caregiver failed to turn in the monthly reports. Another recurring problem is that when someone comes into the shelter looking to adopt, it is not always easy or even possible to let him or her know about all the animals available for adoption.

Ideally, the shelter would like people to be able to register as a volunteer online. They would like to be able to call up a list of all available foster volunteers. They would also like to be able to pull up all the animals of the kind a potential adopter is interested in and know exactly where those animals are and who is caring for them.

Problem 1: Please list the requirements for Coply Pets.

Problem 2: Please produce the corresponding ER Diagram based on Problem 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!