Question

CREATE AN ERD FOR THE CASE BELOW

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

Answer 1

To design a database to track the animal at the shelter along with who is keeping the animal at which place All the record must be kept in the database . database is used to hold the data in tables (Rows and Columns).

ER_diagram: ERD stands for "Entity Relationship Diagram" represents structure of database how the Rows are related to each other and relationship between tables in database. Three things are included in the ER-Diagram that are Entity,Attributes and Relationship.

Entity:- Entity are the things for which user store the data information. An entity is thing , person name, place, event.

Attributes:- Attributes are the sub-parts or collected data for the entity such as book is an entity and author of book is an attribute of entity book.

Relationship:- Relationship specifies the relation between entities.

Animal Related:- Shelter staff keep the record related to animals such as Animal_ID,species, breed, age ,gender ,size, arrival_date, cost, Location. Medicine(vacination),food,cage occupancy,

Adopter Related:- NAme of adopter, number, E-mail address,date of birth,address, animal adopted. shelter needs to keep of adoption date , cost, address.

In case if adopter wants to return the animal back to shelter. Here the shleter system should allows that animal to live back in the shelter.

Staff Related :- Staff needs to keep record of both date adoptation date and delivery date of an animal. it may includes some other points such as w heather ,cage occupancy etc.

Location:- Location_ID,type, size,species,building.

Building Related:- Building_ID,address,Phone number.

All this record is stored and managed in the database tables to keep track of animle's data at shelter.

Business Rules:- -> Only members of shelter staff allows to process new animal delivery and adoptation.

-> ID of an animal Is not used by other animal in case if animal adopted and deliver to the new location then that animal were the only one who has their unique ID no animal can given that ID.

-> Worker should assign the unique ID to each animal of shelter.

-> If adopter returns animal back to shelter then the previous ID can be assign to the animal.

-> Keep the data such as animal ID, Arrival date , cage number.