How deekshas07/student-course-management-system works
The Student Course Management System lets staff use a dashboard and CRUD screens to manage programs, faculty, courses, students, and student course attempts. The frontend services send REST requests to Express routes, which delegate domain operations to models backed by Microsoft SQL Server. The README documents the full set of management areas; the sampled source confirms the server dispatch pattern and several route-to-model and model-to-database interactions. Some frontend page wiring and model implementations were not sampled, so those internal links are shown at subsystem level.
Main entry points: server.js Express server · db.js SQL connection · App.js App routes · services API services
Components 20
Frontend
- App routes
frontend/src/App.js - Dashboard
frontend/src/pages/Dashboard.js - Management pages
frontend/src/pages - Attempt pages
frontend/src/pages - API services
frontend/src/services - HTTP client
frontend/src/services/api.js
REST API
- Program routes
backend/routes/programRoutes.js - Faculty routes
backend/routes/facultyRoutes.js - Course routes
backend/routes/courseRoutes.js - Student routes
backend/routes/studentRoutes.js - Attempt routes
backend/routes/attemptRoutes.js
Domain data
- Program model
backend/models/Program.js - Faculty model
backend/models/Faculty.js - Course model
backend/models/Course.js - Student model
backend/models/Student.js - Attempt model
backend/models/StudentCourseAttempt.js
Runtime
- Express server
backend/server.js - SQL connection
backend/config/db.js
Other components
- Staff user
- SQL Server
Connections 24
- Staff user → App routes: uses
- App routes → Dashboard: renders
- App routes → Management pages: routes to
- App routes → Attempt pages: routes to
- Management pages → API services: requests data
- Attempt pages → API services: requests data
- API services → HTTP client: uses
- HTTP client → Express server: HTTP requests
- Express server → Program routes: dispatches
- Express server → Faculty routes: dispatches
- Express server → Course routes: dispatches
- Express server → Student routes: dispatches
- Express server → Attempt routes: dispatches
- Program routes → Program model: calls
- Faculty routes → Faculty model: calls
- Course routes → Course model: calls
- Student routes → Student model: calls
- Attempt routes → Attempt model: calls
- Program model → SQL connection: queries via
- Faculty model → SQL connection: queries via
- Course model → SQL connection: queries via
- Student model → SQL connection: queries via
- Attempt model → SQL connection: queries via
- SQL connection → SQL Server: connects