Defines actors, problem evidence, measurable metrics (M-01..M-04), strict exclusions of real personal data, and scope boundaries across all academic modules.
10-Stage SPECTION Engineering Journey Timeline
Verifiable lifecycle states grounded in real repository artifacts and executed automated tests
Specifies functional and non-functional requirements for Students, Courses, Enrollments, Activities, privacy controls, and acceptance criteria.
Maps polyglot architecture (Python/SQLite + Next.js static export), Mermaid data flows, relational invariants, storage ports, and trust boundaries.
Details TypeScript strict contracts for Student, CourseItem, Enrollment, and AcademicActivity, CSV formula guard, and multi-entity storage recovery.
Records seven explicit architectural decisions including Next.js static export, opt-in localStorage, Python coexistence, and relational domain evolution.
Defines bounded feature specifications and Given/When/Then acceptance criteria across Students, Courses, Enrollments, and Activities.
Sequences execution from Discovery and Specification to Architecture, Bounded Implementation, Quality Gate, Release, and Portal Integration.
Breaks the web workspace into 15 verifiable engineering tasks mapped directly to requirements and automated test suites.
Verifies all requirements against automated Python, Vitest unit/component, Playwright E2E browser, and static export build checks.
Records actual test execution outputs, live GitHub Pages deployment verification, screenshots, and explicit human review checkpoints.
Visual Traceability Matrix (Requirements -> Code -> Automated Tests)
Direct mapping between RF/RNF IDs, feature identifiers, implementation modules, and automated verification suites
| Requirement ID | Feature | Description | Implementation | Automated Tests | Status |
|---|---|---|---|---|---|
| RF-001..RF-007 | FEAT-001..004 | Python/SQLite relational registry (students, courses, enrollments, activities) | students.py | tests/test_students.py (8 tests) | Tests Passed |
| RF-WEB-001..005 | FEAT-WEB-001 | Student registration, DEMO-0001 normalization, validation & duplicate guard | web/lib/domain/students.ts | students.test.ts, academic-lab.spec.ts | Tests Passed |
| RF-WEB-006..010 | FEAT-WEB-001 | List, search, filter, sort, edit, and confirmed student deletion | web/app/students/page.tsx, ConfirmDialog.tsx | students.test.ts, academic-lab.test.tsx | Tests Passed |
| RF-WEB-011..014 | FEAT-WEB-001 | Idempotent demo seed, confirmed local clear, safe CSV export & live dashboard | web/lib/domain/students.ts, web/app/page.tsx | students.test.ts, academic-lab.test.tsx | Tests Passed |
| RF-WEB-015..018 | FEAT-WEB-002 | Synthetic Courses CRUD (COURSE-01), workload (15-240h), deletion guard & CSV | web/lib/domain/academic.ts, web/app/courses/page.tsx | academic.test.ts, academic-lab.spec.ts | Tests Passed |
| RF-WEB-019..022 | FEAT-WEB-003 | Relational Enrollments (ENR-0001), student+course+term uniqueness, status & CSV | web/lib/domain/academic.ts, web/app/enrollments/page.tsx | academic.test.ts, academic-lab.spec.ts | Tests Passed |
| RF-WEB-023..026 | FEAT-WEB-004 | Academic Activities (ACT-0001), score bounds (0-100), status, avg score & CSV | web/lib/domain/academic.ts, web/app/activities/page.tsx | academic.test.ts, academic-lab.spec.ts | Tests Passed |
| RNF-WEB-001..002 | FEAT-WEB-001..004 | Responsive layout and keyboard/screen-reader accessibility | web/components/AppShell.tsx, globals.css | academic-lab.spec.ts (mobile & dialog roles) | Tests Passed |
| RNF-WEB-003..006 | FEAT-WEB-001..004 | Memory default, opt-in localStorage, zero server transmission, error fallback | web/lib/storage/storage.ts, PrivacyBanner.tsx | storage.test.ts, academic-lab.spec.ts | Tests Passed |
| RNF-WEB-007 | FEAT-WEB-001..004 | Static export build for GitHub Pages deployment | web/next.config.mjs, .github/workflows/academic-lab.yml | npm run build (web/out) | Tests Passed |