Yun.Bun

---

PupTrack platform

Imagine PupTrack: a comprehensive platform designed to transform shelter management and canine welfare. It enables users to:

• Monitor shelter dogs by tracking details such as name, breed, age, vaccination history, and medical treatments
• Record adoption data, including adoption dates, adopter information, and follow-up details
• Analyze trends in canine health, adoption rates, and breed popularity
• Support smarter decisions for shelter staff while also fostering community engagement

And here’s a fun insight – did you know a dog’s nose print is as unique as a human fingerprint? Beyond identification, a dog’s nose can be a window into its well-being. Variations in moisture or texture can sometimes indicate dehydration or signs of illness.

---

How Might This Look Like?

• Dogs: stores profiles of adoptable or adopted dogs (e.g. DogID, Name, Breed, Age, Status)

• Adoptions: tracks adoptions (e.g. AdoptionID, DogID, AdopterID, AdoptionDate)

• HealthRecords: logs medical history and checkups (e.g. RecordID, DogID, VisitDate, VetNotes, Vaccinations)

• Users: details about adopters or shelter staff (e.g. UserID, Name, Email, Role)

---

Choosing the Right Database Type

Relational Databases (RDBMS)

Examples: PostgreSQL, MySQL

Good when:

• You have neat, structured tables like Dogs, Adoptions, etc.
• Different data tables are connected (e.g., a dog belongs to an adopter)
• You need reliable, secure transactions (e.g., no lost adoption records)

Non-Relational Databases (NoSQL)

Example: MongoDB

Good when:

• Data can vary a lot (some dogs have more or less info)
• You store things like documents, photos, or location info
• You want flexibility rather than strict table rules

---

Choosing the right database can feel overwhelming at first, but it gets easier once you know what your data needs. Whether you’re adopting dogs or tracking health records, structured or flexible – there’s a database that fits your story.