This project is designed to automate the work of the dean's office, enabling the management of student grades and performance analysis. The system provides an intuitive web interface for handling groups, students, teachers, subjects, and grades.
- User Roles: Regular users can only view data, while administrators have full access to modify records.
- Security: Authentication via JWT, passwords are securely stored using bcrypt hashing.
- Performance Analysis: Flexible filtering options for analyzing grades by students, groups, subjects, teachers, and academic years.
- Graphical Reports: Visualization of analysis results.
- Database Integrity: Ensures data consistency using constraints, transactions, and triggers.
- Language: Python
- Framework: FastAPI
- Database: PostgreSQL
- Migrations: Alembic
- Language: TypeScript
- Framework: React
- Build Tool: Vite
- Python 3.10+
- Node.js 16+
- PostgreSQL
- Install dependencies:
pip install -r requirements.txt - Configure database connection in the .env file:
DATABASE_URL=postgresql://user:password@localhost/dbname
- Apply migrations:
alembic upgrade head
- Start the server:
uvicorn main:app --reload
- Install dependencies:
npm install
2. Start the application:
npm run dev
This project provides a REST API for data management. Full documentation is available at:
http://localhost:8000/docs
- Login page
- Analytics Section
- Groups section
- People section
- Report example
