Individual Case Study 2020

Petfinder Database Design

A case studies of relational database design and query based on available data and information on Petfinder.com using mySQL.

Milestone

1. Inital Study (1 week)
2. Database Design & Data Collection (1.5 weeks)
3. Implementation and Data Loading (1.5 weeks)
4. Testing and Evaluation (1 week)

• Proposal
• DB: ER Model
• DB: Normalization
• SQL Schema
• End-User Views
• Analytical Queries

Code

• Schema Design
• SQL Queries

Analytic Queries

1. Potential adopter analysis
2. In-shelter animal data analysis
3. Animal shelter intakes analysis
4. Animal shelter geographic distribution analysis

Visualization

• Related Project: 2020 US Animal Shelter Intake Geo Analysis
• Interactive Story-teling Dashboard
• Featured Viz of The Day (VOTD)

Files

• Schema in mySQL
• Sample Dataset
• Queries: Provider | Adoptor | stored procedure