The county animal shelter has hired you to design a database
to track the animals at the shelter along with the people who adopt
them. You have worked with the staff at the shelter, analyzed how
they perform the work now, performed user requirements gathering
and you have created a DFD.
Below you will find the description of the entities and
attributes defined during this process.
Animal: animal_id, species, breed, age, gender, size,
spay/neuter, intake_date, location, cost
Adopter: name, phone, email, date of birth, address, animal
adopted
Location: location id, type, size, species, building
Building: building id, address, phone
Some business rules you came up with during your work:
Animals may be returned to the shelter within 10 days
circumstances change such that the animal cannot be kept.
Staff would like to keep track of in which location (cages)
the animals are kept over time
Draw ERD diagram