University Student Information System API

REST API for university course registration and academic management.

Features

• Course Registration - Students can register for courses with pattern selection (lectures, labs, tutorials)
• Prerequisite Validation - Automatic checking of course requirements and academic standing
• Real-time Capacity Management - Prevents over-enrollment with immediate feedback
• Grade Management - Complete grade entry, automatic letter grade calculation, and GPA tracking
• Smart GPA Calculations - Semester and cumulative GPA with incomplete semester handling
• Multi-role Authentication - Separate interfaces for students, educators, and administrators
• Teaching Assistant Controls - Role-based restrictions for grade entry permissions
• Schedule Management - Dynamic timetable generation with conflict detection

Database Structure

The system uses a relational database with key entities:

• Students → Academic Years → Semesters → Enrollments
• Courses with Prerequisites and Department associations
• Registrations containing Schedule Patterns (lecture/lab/tutorial sections)
• Time Slots with Educator assignments and location details
• Global Settings for managing current academic year and registration periods

Students select specific patterns when enrolling, creating flexible scheduling while maintaining capacity limits.

API Overview

📖 Complete API Documentation: See API.md for detailed request/response examples and endpoint specifications.

Authentication

• POST /auth/login/ - User login with JWT token
• POST /auth/refresh/ - Refresh authentication token
• GET /auth/me/ - Get current user info

Student Operations

• GET /student/info/ - Student profile and academic standing
• GET /student/grades/ - Complete academic transcript
• GET /student/current-semester/ - Current semester courses and grades
• GET /student/available-registrations/ - Courses available for registration
• POST /student/register/ - Register for courses with pattern selection
• GET /student/timetable/ - Personal class schedule

Educator Operations

• GET /educator/info/ - Educator profile information
• GET /educator/current-courses/ - List of taught courses this semester
• GET /educator/course/{id}/ - Detailed course view with student roster and grades
• PUT /educator/course/{id}/grades/ - Batch update student grades with automatic GPA calculation
• GET /educator/timetable/ - Teaching schedule

Admin Operations

• Full CRUD operations for all entities:
  • /students/, /courses/, /educators/, /departments/
  • /registrations/, /enrollments/, /schedule-patterns/, /time-slots/
• GET|PUT /settings/ - Global system settings management

Quick Start

Prerequisites

• Python 3.8+
• pipenv

Installation

1. Clone the repository

git clone https://github.com/Rabea25/SISAPI.git
cd SISAPI

2. Install dependencies

3. Activate virtual environment

4. Set up database

python manage.py migrate
python manage.py createsuperuser

5. Run the server

python manage.py runserver

The API will be available at http://localhost:8000/

Usage Examples

Student Course Registration

POST /student/register/
[
  {
    "registrationId": 123,
    "schedulePatterns": [
      {"patternId": 456},  // Main Lecture
      {"patternId": 789}   // Lab Section A
    ]
  }
]

Educator Grade Management

PUT /educator/course/123/grades/
[
  {
    "enrollmentId": 456,
    "coursework": 45,
    "exam": 42
  },
  {
    "enrollmentId": 789,
    "coursework": 38,
    "exam": 44
  }
]

Response:

{
  "successful": [
    {
      "enrollmentId": 456,
      "studentName": "Alice Johnson",
      "letterGrade": "A-",
      "semesterGPA": 3.2,
      "cumulativeGPA": 3.4
    }
  ],
  "failed": [],
  "message": "Updated 2 students successfully"
}

Key Features

Intelligent GPA System

• Automatic Letter Grade Assignment - Converts numeric scores to letter grades (A+ to F)
• Smart Semester Handling - Incomplete semesters show 0.0 GPA and don't affect cumulative GPA
• Role-Based Grade Entry - Teaching Assistants restricted from entering final exam grades
• Real-time Calculations - GPA updates immediately when grades are entered

Academic Business Logic

• Prerequisite Enforcement - Students can only register for courses they're eligible for
• Capacity Management - Real-time enrollment limits with pattern-specific restrictions
• Schedule Conflict Prevention - Automatic detection of time slot overlaps
• Department Access Control - Students access courses from their department plus general education