Question

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 to create an ERD. 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 if 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

If there are questions you have on this, start with http://hatsweb.org

Please note that the animal shelter has many more attributes for each animal, but in the interest of brevity, I’ve left them out.

I need ERD for this ?

Answer 1

E-R Diagram-

• This Er model has 4 main entities-

1. Animal
2. Adopter
3. Location
4. Building

• This Er model has has been converted into 3NF
• Here each entity and its attributes are in tabular form
• Data types of each attribute has been mentioned with it
• The primary key as PK and foriegn key as FK has been mentioned there.

If any doubt, please feel free to ask and comment, i would like to answer them.
Thank you