EPIC-3: Smart SIS & Admission Inquiry Engine
📋 EPIC Overview
| Field | Value |
|---|---|
| EPIC ID | NGE-13 |
| Priority | 🟠 P1 - High (Revenue Critical) |
| Story Points | 89 SP |
| Duration | 8 weeks (4 sprints) |
| Dependencies | EPIC-1, EPIC-2 |
🎯 Goals
- Complete Student Information System (SIS)
- Online Admission Portal with AI Chatbot
- Document Management (TC, Birth Certificate, Aadhaar)
- Class & Section Management
- Bulk Promotion & Transfer System
- Parent Portal
📖 User Stories
| Story ID | Title | Points | Sprint |
|---|---|---|---|
| NGE-13-1 | Student Registration & Profile | 13 | Sprint 7 |
| NGE-13-2 | Class & Section Management | 8 | Sprint 7 |
| NGE-13-3 | Admission Inquiry with AI | 21 | Sprint 8 |
| NGE-13-4 | Document Management | 13 | Sprint 8 |
| NGE-13-5 | Bulk Promotion & Transfer | 13 | Sprint 9 |
| NGE-13-6 | Transfer Certificate | 8 | Sprint 9 |
| NGE-13-7 | Parent Portal | 13 | Sprint 10 |
🏗️ Architecture
🎯 Tech Stack for EPIC-3
| Component | Language | Framework | Purpose |
|---|---|---|---|
| SIS API | Node.js | NestJS | Student CRUD, Classes |
| Document Service | Node.js | NestJS | S3 upload/download |
| Admission Chatbot | Python | FastAPI | Claude AI integration |
| Background Jobs | Node.js | BullMQ | Bulk promotion |
| Database | - | PostgreSQL 16 | Data storage |
| Cache | - | Redis 7.4 | Session, hot data |
💾 Key Database Tables
| Table | Description |
|---|---|
students | Student profiles with encrypted PII |
guardians | Parent/guardian information |
classes | Class definitions (LKG to 12) |
sections | Sections with capacity |
admission_inquiries | Inquiry tracking with AI chat |
student_documents | Document storage metadata |
student_promotions | Promotion history |
transfer_certificates | TC records with QR verification |