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 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

Answer 1

E-R Diagram-

This Er model has 4 main entities-
Animal
Adopter
Location
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.

THANK YOU!! PLEASE VOTE