community care platform · oracle sql · cpsc 304

StrayCare

a community tool for tracking stray animals. every feeding, vaccination, and volunteer action lands in an oracle schema so nothing falls through the cracks.

Oracle SQLVolunteer networkPlus CodesAnimal profilesAnalyticsCourse project

how it works

every stray, mapped.

each pin is a log entry. feeding, vaccination, and sighting all tied to a plus code location so nothing slips through the cracks and every volunteer knows exactly where to go.

Plus Code grid · stray locations

what it does

animal profiles

profiles for each stray with age, traits, and location, tied to feeding and vaccine history.

volunteer communities

volunteers are grouped by community so people only manage animals in their area.

location-aware care

Plus Codes anchor every animal and volunteer, so filtering by neighbourhood actually works.

vaccination tracking

vaccination records include type, dose, date, and vet, so gaps show up fast.

community analytics

oracle views make it easy to pull feeding frequency, volunteer activity, and area coverage.

access control

session auth and role checks keep edits limited to the right community.

database-first design

we started with the schema.

once the oracle tables made sense, the ui was straightforward: it was just exposing what the database already knew.

Plus Codes are the location keys. vaccinations are stored as separate events so we can analyze them without mixing them into feeding history.

normalized tables for animals, volunteers, communities, vets.
bridge tables for volunteer–community and animal–location links.
separate vaccination and feeding event tables with timestamps.
views for last-fed, vaccination gaps, and volunteer activity.

StrayCare ER Diagram · Oracle SQL · abstract version

team

three people, a community of strays, and one oracle schema.

Kush Sharma

builder

Sayuj

builder

Lucas

builder