Team

FP
Fabrizio Petrozzi
Solution Architect & UI Lead
Contributions: mapped the static site into the MVC layout, built shared Razor components, and refreshed the EduInsight theme (layout + eduinsight.css).
AM
Andrey Martynenko
MVC Workflow & Documentation
Contributions: authored the Home/Insights controllers and views, wired CRUD flows with validation, and produced the updated About/README content.
BR
Bryan Reeder
Data Services & Testing
Contributions: implemented the JSON-backed enrollment repository, seeded data/ERD updates, and verified CRUD plus persistence across environments.
HB
Hammaz Buksh
API & Deployment Engineer
Contributions: integrated the College Scorecard API, configured environment secrets, deployed to Azure, and updated the embedded Botpress chatbot.

Logical data model

Relational view for EduInsight.

ERD showing Student, Program, and Term tables feeding the Enrollment fact table through one-to-many relationships

The ERD illustrates our long-term design: Students, Programs, and Terms each hold canonical details and connect to the Enrollments fact table through one-to-many relationships. This layout supports richer reporting while keeping enrollments as the central record tying those entities together.

Repository

Code and documentation live in our GitHub repo.

Open GitHub repository