AI Smart Campus System
Decoupled campus management platform combining a React frontend, Laravel 12 API, and AI integrations.
My Role
Team Leader and Database Lead
Category
Academic Team Project
Timeline / Date
2026
Primary Stack
React & Next.js / Vite
01 / The Problem
The Operational & Engineering Challenge
University students and faculty often navigate fragmented web portals for academic information, administrative requests, and campus notices. Manual query handling creates administrative bottlenecks and delays critical support for students.
02 / The Solution
Architecture & System Implementation
Architected a modern decoupled full-stack platform featuring a responsive React & Vite Single Page Application connected to a high-performance Laravel 12 REST API with Sanctum token authentication. Integrated OpenAI and Gemini APIs to deliver intelligent, automated student assistance workflows.
03 / Platform Showcase
Northern University of Business & Technology Khulna Portal
Institutional landing page for NUBTK featuring integrated navigation, student indicators (8,400+ active students), and 24/7 AI-assisted academic support.
04 / Key Features
Core System Capabilities & Workflows
Led the academic project team and database architecture.
Feature 01
Designed and coordinated the MySQL-backed data layer.
Feature 02
Integrated a React and Vite frontend with a Laravel 12 REST API.
Feature 03
Used Laravel Sanctum for secure API authentication.
Feature 04
Integrated AI APIs (Gemini & OpenAI) for intelligent campus workflows.
Feature 05
Implemented academic and student-management workflows.
Feature 06
05 / User Experience & Dashboards
Role-Based Portals: Faculty & Student Workspaces
Purpose-built interfaces tailored to institutional personas, streamlining teaching oversight and student degree tracking.
Faculty & Admin Teaching Workspace
Instructor dashboard offering high-level academic tracking across enrolled students, class schedules, weekly agendas, attendance benchmarks (69% average), and at-risk student alerts.
Student Learning & Course Progress Hub
Comprehensive student portal displaying registered courses (Mobile Computing, Introduction to Computers, Structured Programming), upcoming lecture schedules, and historical CGPA tracking across semesters (3.51 - 3.61).
06 / AI Intelligence & Workflows
Intelligent Early Warning & Chat Assistant
Integrated machine intelligence powered by Google Gemini and OpenAI models, analyzing live student attendance, CGPA trends, and academic queries.
AI Risk Alert & Early Warning System
Database-backed academic diagnostic engine calculating attendance thresholds and CGPA trajectories to categorize student risks (Critical, Medium, On Track) with tailored recovery recommendations.
AI Assistant Conversational Workspace
Interactive AI chat workspace powered by Gemini and OpenAI models, enabling instructors and students to generate lesson plans, analyze student performance, and query campus schedules with authenticated account context.
07 / Mobile Experience
Responsive Mobile-First Experience
Fully responsive mobile application interface running on Render cloud (system-ce9i.onrender.com), providing instantaneous access to campus tools, authentication, and academic status across mobile viewports.
08 / Engineering Contribution
My Specific Role & Responsibilities
Team Leader and Database Lead responsible for coordinating project milestones, designing the MySQL data layer, building the Laravel 12 RESTful API with Sanctum, integrating AI APIs, and connecting the React frontend.
09 / Technology Architecture
Full-Stack Technology Decisions
Backend & APIs
- Laravel 12
- PHP 8.3
- RESTful API
- Laravel Sanctum
Frontend & UI
- React 19
- Next.js / Vite
- TypeScript
- Tailwind CSS
Database Layer
- MySQL
- Relational Schema Design
- Query Optimization
Integrations & Tools
- OpenAI API
- Gemini API
- Render Cloud
- Postman
10 / Data Layer
Database Architecture & Relational Schema
Relational data layer engineered to support high-concurrency API requests, student profiles, departmental hierarchies, and AI interaction logging.
Key Relational Entities
- users & students: Manages authenticated credentials and academic profiles
- departments & courses: Houses institutional curriculum and program mapping
- academic_queries: Tracks student submissions and resolution statuses
- ai_conversations: Logs AI prompts and responses for auditability and session continuity
Schema Design Principles
- Optimized composite indexing for fast student and course lookups
- Foreign key cascades maintaining data consistency across department transfers
- Encrypted token storage via Laravel Sanctum personal access tokens
11 / System Flow
API Architecture & Data Flow Lifecycle
Stateless RESTful API architecture connecting the React SPA client to the Laravel backend and third-party AI models.
12 / Problem Solving
Engineering Challenges & Technical Solutions
Challenge 01
Protecting sensitive third-party AI provider API keys while enabling client-side interactive campus queries.
Engineered Solution:
Created secure server-side controller proxies in Laravel 12 that securely manage API keys in environment variables, ensuring zero exposure to the client application.
Challenge 02
Ensuring responsive user experience during asynchronous AI model inference.
Engineered Solution:
Implemented animated loading skeletons, optimistic state management in React, and robust server-side error fallbacks.
13 / Result & Verification
Project Delivery & Technical Achievements
Delivered a fully functioning full-stack AI-integrated academic platform with a live hosted demonstration and complete source code repository.
- Live demonstration hosted online on Render
- Successful team leadership and database architecture execution
- Published open-source repository on GitHub