• Frontend: https://learntrack.pages.dev - deployed on Cloudflare Pages
• Backend: Deployed on Render using Docker

DBMS SQLite College Project

Learn Track streamlines course access, submission tracking, and academic progress for students and faculty. It supports resource uploading, grading, feedback, and certificate downloads. Personalized dashboards give real-time academic analytics. The system supports semester-based enrollment, auto-notifications, and bulk result uploads.

User Responsibilities

• Student: Enroll in courses and view syllabus; Submit assignments and check grades; Access study material and feedback
• Faculty: Upload lecture content; Grade submissions and provide remarks; Track student performance
• Admin: Approve new course creation; Manage user permissions; Generate result analysis and performance reports

Allowed Tools

• Frontend: React, framer-motion, Tailwind CSS, etc.
• Backend: Python (FastAPI) with SQLite3

• Overview
• Features
• Tech Stack
• Folder Structure
• Getting Started
  • Prerequisites
  • Installation
  • Running the Application
• Frontend
  • Frameworks & Libraries
  • Routing & Layouts
  • Contexts
  • Pages & Components
• Backend
  • Framework & Setup
  • API Endpoints
• Database
  • Schema
  • ER Diagram
  • Migrations
• Workflows
  • Authentication Flow
  • Course Management Flow
  • Assignment Submission & Grading Flow
  • Notification Flow
• Diagrams
  • System Overview
  • Frontend Routing
  • Backend API Flow
• Environment Variables
• Contributing
• License

LearnTrack streamlines course access, submission tracking, and academic progress for students and faculty. It supports resource uploading, grading, feedback, and certificate downloads. Personalized dashboards provide real-time analytics. The system supports semester-based enrollment, auto-notifications, and bulk result uploads.

• User authentication & role-based access (student, faculty, admin)
• Course management (CRUD, enrollment)
• Assignment creation, submission, grading
• File uploads for materials and submissions
• Real-time notifications
• Dashboard analytics and reports
• Dark/light theme support

• Frontend: React, TypeScript, Framer Motion, Tailwind CSS, React Router
• Backend: FastAPI (Python), SQLite
• Database: SQLite3
• Authentication: password hashing (bcrypt)

LearnTrack/
├── backend/            # FastAPI server
├── public/             # Static assets
├── src/                # React application
│   ├── components/     # UI & dashboards
│   ├── contexts/       # Auth, Theme, Notifications
│   ├── layouts/        # Auth & Main layouts
│   ├── pages/          # Route-based pages
│   └── App.tsx         # Routes configuration
├── database.db         # SQLite database
├── package.json        # Frontend dependencies
└── Readme.md             # Project documentation

• Node.js >= 18
• pnpm or npm
• Python 3.9+
• pip

# Frontend setup
cd LearnTrack
pnpm install

# Backend setup
cd backend
pip install -r requirements.txt

Download, load, and run the pre-built Docker image:

curl -L https://github.com/0xarchit/LearnTrack/releases/download/2.1.0/learntrack_v2_1.tar -o learntrack_v2_1.tar
docker load -i learntrack_v2_1.tar
docker run --rm -d --name learntrack_v2_1 -p 5000:5000 -p 5173:5173 learntrack_v2_1

# Start backend (FastAPI)
cd backend
uvicorn app:app --host 0.0.0.0 --port 5000 --reload

# Start frontend (Vite)
cd LearnTrack
pnpm dev

Open http://localhost:5173 in your browser.

For testing purposes, you can use the following demo accounts:

• React & TypeScript
• React Router v6
• Framer Motion for animations
• Tailwind CSS for styling
• Context API for state (Auth, Theme, Notifications)

• Public routes under AuthLayout
• Protected routes under MainLayout
• Role-based guard via ProtectedRoute component

• AuthContext: Manages user, role, token
• ThemeContext: Toggles dark/light mode
• NotificationContext: Handles in-app notifications

• LandingPage: Marketing page
• Login/Register/ForgotPassword
• Dashboard: Role-specific overview
• Courses/Assignments/Materials/Grades/Profile
• Admin & Faculty panels under /pages/admin, /pages/faculty
• Reusable UI in components/ui (Button, Card, Input)

• FastAPI application in backend/app.py
• Middleware: CORS
• File uploads via StaticFiles
• SQLite connection helper and migrations

POST   /api/register
POST   /api/login
GET    /api/courses
GET    /api/courses/{id}
POST   /api/courses
PUT    /api/courses/{id}
DELETE /api/courses/{id}
GET    /api/enrollments?user_id=
POST   /api/enroll
DELETE /api/enroll
GET    /api/assignments
POST   /api/assignments
GET    /api/assignments/{id}
DELETE /api/assignments/{id}
GET    /api/assignments/{id}/submissions
POST   /api/assignments/{id}/submissions
PUT    /api/submissions/{id}/grade
GET    /api/materials
POST   /api/materials
DELETE /api/materials/{id}
GET    /api/grades?user_id=
GET    /api/notifications?target_role=
POST   /api/notifications
PUT    /api/notifications/{id}
DELETE /api/notifications/{id}
GET    /api/reports/performance
GET    /api/reports/metrics

Run backend and go http://localhost:5000/docs for checking endpoints

• users: id, name, email, password, role, phone, address, department, joinDate
• courses: id, title, instructor_id, description, status, duration, thumbnail_url
• enrollments: user_id, course_id
• assignments: id, title, course_id, description, due_date, max_score
• submissions: id, user_id, assignment_id, file_url, description, submitted_at, grade
• materials: id, title, course_id, type, url
• grades: id, user_id, course_id, grade
• notifications: id, message, type, target_role, created_at

erDiagram
    USERS {
        int id PK
        string name
        string email
        string password
        string role
        string phone
        string address
        string department
        string joinDate
    }

    COURSES {
        int id PK
        string title
        int instructor_id FK
        string description
        string status
        string duration
        string thumbnail_url
    }

    ENROLLMENTS {
        int user_id PK,FK
        int course_id PK,FK
    }

    ASSIGNMENTS {
        int id PK
        string title
        int course_id FK
        string description
        string due_date
        int max_score
    }

    MATERIALS {
        int id PK
        string title
        int course_id FK
        string type
        string url
    }

    SUBMISSIONS {
        int id PK
        int user_id FK
        int assignment_id FK
        string file_url
        string description
        string submitted_at
        int grade
    }

    GRADES {
        int id PK
        int user_id FK
        int course_id FK
        int grade
    }

    NOTIFICATIONS {
        int id PK
        string message
        string type
        string target_role
        string created_at
    }

    USERS ||--o{ COURSES : teaches
    USERS ||--o{ ENROLLMENTS : enrolls
    COURSES ||--o{ ENROLLMENTS : has
    COURSES ||--o{ ASSIGNMENTS : contains
    COURSES ||--o{ MATERIALS : includes
    USERS ||--o{ GRADES : receives
    COURSES ||--o{ GRADES : for
    USERS ||--o{ SUBMISSIONS : submits
    ASSIGNMENTS ||--o{ SUBMISSIONS : has

On startup, init_db() adds missing columns and migrates data.

flowchart TD
  A[User] -->|POST /api/login| B[AuthContext]
  B --> C[Store user & role]
  C --> D[ProtectedRoute grants access]

flowchart LR
  U[Admin] -->|Create Course| API["/api/courses POST"]
  API --> DB["SQLite courses table"]
  U -->|View Courses| API["/api/courses GET"] --> U

sequenceDiagram
  Student->>Frontend: Submit form
  Frontend->>API: POST /api/assignments/{id}/submissions
  API->>DB: Insert submission
  Faculty->>API: GET /api/assignments/{id}/submissions
  Faculty->>API: PUT /api/submissions/{id}/grade

flowchart TD
  A[Admin/Faculty] -->|POST /api/notifications| B[NotificationContext]
  B --> API
  API --> DB
  Student -->|GET /api/notifications| B --> UI

flowchart LR
  subgraph Frontend
    FE[React App] 
  end
  subgraph Backend
    BE[FastAPI]
    DB[SQLite3]
  end
  FE -->|HTTP| BE -->|SQL| DB

flowchart LR
  Public --> AuthLayout --> Login/Register
  Protected --> MainLayout --> Dashboard/Courses/... 

flowchart TD
  Client --> FastAPI
  FastAPI --> DB
  FastAPI --> Storage["/uploads folder"]

• VITE_API_URL: Base URL for backend (default http://localhost:5000)

1. Fork the repo
2. Create a new branch
3. Submit a pull request

MIT © 0xarchit