Selected work

Student/Course Manager

A Full Stack system for managing students, courses and the links between them.

React
Node.js
PostgreSQL
Sequelize
Axios

Overview

An administrative application with forms, filters and detail pages that centralizes student and course records in a relational database.

The challenge

Model the relationship between students and multiple courses, preserve data integrity and provide clear management workflows in the frontend.

The solution

The backend uses Express, Sequelize and migrations to structure students, courses and their association table in PostgreSQL. The React frontend consumes the API with Axios and organizes creation, editing, details and search flows.

Architecture

React frontend with React Router, Hooks and Axios
Node.js and Express REST API
Sequelize ORM with versioned migrations
PostgreSQL many-to-many relationship

Key deliverables

Student and course CRUD
Multiple course assignments per student
Search filters and detail pages
Validation and migrations for data integrity