Case Study · Education & Relational Systems

SIMS

SIMS (Student Information Management System) is a departmental student-information system created for the Computer Science program of Isabela State University – Echague Campus. Rather than focusing primarily on enrollment, the system centralized student profiles, academic and extracurricular achievements, Hall of Fame recognition, and student-organization relationships.

As System Architect and Developer, I designed and implemented the full-stack application, relational data structure, role-based access, achievement workflows, and local-network deployment.

Domain: Education (Departmental SaaS)
My Role: System Architect + Developer
Provenance: Isabela State University – Echague Campus
Year & Origin: 2021 · Capstone Project
Core Stack: PHP · MySQL · Auth0 · Tailwind CSS
Deployment: Local LAN Server Setup

Overview & Digitalization Purpose

SIMS was developed to digitize and centralize student records that were previously scattered across physical documents and uncoordinated lists within the Computer Science department.

Rather than duplicating university-wide registrar functions (such as tuition billing or official grade processing), SIMS focused on preserving and presenting student accomplishments, certifications, awards, and student-organization memberships.

System Positioning Departmental student profile, achievement recognition, and organization relationship management.

Engineering Focus Full-Stack · Data

Case Study Narrative Flow

The central system narrative demonstrates how manual student records were transformed into a structured departmental recognition platform:

Manual / Scattered Student Information
        ↓
Structured Student Profiles
        ↓
Academic & Extracurricular Achievement Records
        ↓
Student-Organization Memberships & Positions
        ↓
Departmental Hall of Fame & Recognition
        ↓
Role-Based Department Access (Admin, Faculty, Student, Chair)
        ↓
Locally Deployed Department System (LAN Access)

User Roles & Access Control

The application enforced role-based access control to tailor interface views and operational capabilities across different department stakeholders:

Department Administrator: Full system record management, achievement verification, and organization data oversight.
Faculty / Instructor: Ability to view, manage, and verify relevant student academic and project records.
Students: Self-service profile viewing, personal achievement submission, and organization membership checks.
Program Chair / Head: Department-level overview reporting and program visibility.
Organization Officers: Management of student organization profiles, activities, and officer lists.

Role-Based Navigation Auth0 login sessions resolved user roles to present role-specific dashboards and menu options.

Student Profile Management

Student profile records centralized essential student identity and departmental involvement in one searchable database:

Student Identity & Profile Data Basic academic metadata, program year, contact information, and profile records.

Integrated Achievement History Chronological list of earned awards, certifications, rankings, and competition recognitions.

Organization Involvement Active and historical memberships in recognized Computer Science student organizations.

Achievement & Recognition Subsystem

The achievement subsystem gave SIMS its distinct identity by capturing diverse student accomplishments beyond standard course grades.

Tracked achievement categories:

Competition Achievements: Hackathons, programming contests, and academic quizzes.
Industry Certifications: Technical skills certifications and online credentials.
Academic Awards: Honor rolls, dean's lists, and research recognitions.
Student Projects: Capstone projects, software demonstrations, and research outputs.
Organization Achievements: Group awards and departmental event rankings.

Student Accomplishment
        ↓
Record Achievement Entry
├── Category & Title
├── Date & Description
├── Ranking / Award Title
├── Supporting Evidence / Photo
└── Related Organization
        ↓
Store in Relational Schema
        ↓
Display on Student Profile & Department Hall of Fame

Departmental Hall of Fame

SIMS featured a central Hall of Fame showcase highlighting top student achievements, competition winners, and program honors.

The Hall of Fame served as a public recognition mechanism within the department, preserving accomplishment history for upcoming student batches.

Recognition Preservation Ensured student awards and competition successes remained visible across academic years rather than being lost over time.

Student Organization Relationships

Student organizations were modeled as relational entities rather than flat text fields, establishing rich connections between students and campus groups:

Student Entity
   │
   ├── Member Of ──────► Student Organization Profile
   │                          ├── Executive Officers & Positions
   ├── Officer Role ──────────┤── Activity / Event Logs
   │                          └── Group Achievements
   └── Membership History ────┘

Relational Data Modeling

SIMS demonstrated early relational schema design using MySQL to connect core entities:

Student ↔ Achievement One-to-many relationship linking students to multiple documented accomplishments.

Student ↔ Organization (Membership & Roles) Many-to-many relationship tracking student involvement, officer positions, and historical terms.

Organization ↔ Achievement & Events Linking group achievements and activities directly to student organization profiles.

Verified Technology Stack

Backend & Database PHP (Full-Stack application logic) · MySQL (Relational database)

Authentication & UI Auth0 (User authentication) · Tailwind CSS (Responsive styling)

Deployment & Testing Local LAN Server Deployment · Manual Functional Testing

Local Network (LAN) Deployment

The system was deployed on a local PHP/MySQL server accessible over the institutional local area network (LAN IP), enabling multiple department computers to access SIMS simultaneously:

Department Local Server (PHP + MySQL Instance)
        │
        └── Local Area Network (LAN IP Access)
              ├── Admin Workstation
              ├── Faculty Computers
              └── Student Lab Workstations

Manual Functional Testing

System quality was validated through manual functional testing routines covering Auth0 authentication, role routing, student profile creation, achievement logging, Hall of Fame rendering, organization updates, and LAN connection sanity checks.

Verified Qualitative Outcomes

Centralized Departmental Records Replaced manual record keeping with a structured, searchable student database.

Visible Achievement Recognition Created a central Hall of Fame showcase preserving student awards and competition successes.

Relational Organization Mapping Connected student profiles with organization memberships, officer roles, and activity records.

Functional Local Network Deployment Successfully operated across department computers over a local LAN setup.

Retrospective & Foundations

Early Relational Data Design

SIMS served as an early full-stack project demonstrating how relational data modeling becomes essential when connecting student profiles, achievements, organization memberships, and officer positions.

Focusing on Recognition Over Administration

By focusing on achievement tracking and Hall of Fame recognition rather than standard enrollment workflows, SIMS provided immediate value to the Computer Science department community.