You have an internship with the local animal shelter. The shelter only provides

Question

You have an internship with the local animal shelter. The shelter only provides a temporary home to cats and dogs. They know that you've taken an information systems course, so they want you to make a database. The database is needed for several reasons. First, the shelter wants to track those who adopt pets from the shelter so dial "thank you" letters can be sent. Along with the "thank you" is a request for donations. Second, the shelter wants to track how many cats and dogs are adopted during any period of time, such as by month or year, so they can measure their success at encouraging pet adoption. Third, the shelter wants to determine how many animals have been adopted by the same person. The shelter only lets a person adopt an animal if they have not adopted an animal from the shelter in the last three months. Adopters are identified by household. You have decided to use the phone number of the household as a way to uniquely identify each one. Pets are identified by a tag number, such as "D217" (for dog number 217) and "C142" (for cat 142). A pet can only be adopted by one household, but a household may adopt more than one pet. Now you need to describe the database. Assignment This database can be built with only two tables: OWNER and PET. List each field that should be in each table Some fields are expressly mentioned in the case, but you are free to add others that you believe are necessary to meet the decision needs of the case. Determine which fields in the tables should be the key fields How do you relate the OWNER table to the PET table? Which field is chosen and why?

Explanation / Answer

1.

OWNER
- PHONE
- NAME
- HOUSEHOLD

PETS
- PET_ID
- OWNER_PHONE
- ADOPTION_DATE

2.

OWNER PRIMARY KEY - PHONE
PETS PRIMARY KEY - PET_ID

3.

PETS.OWNER_PHONE is foreign key related to OWNER.PHONE

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.