Student Management System | Commercial SaaS Edition

Developed by ADS Studio

The Student Management System is a commercial-grade, multi-tier web application developed by ADS Studio. It provides educational institutions and administrators with a modern, secure, and user-friendly platform for student record administration, academic CGPA analytics, and real-time database management.

---

🌟 Brand Identities

1. Company Brand: ADS Studio

• Company Name: ADS Studio
• Official Logo: Embedded across official company touchpoints (Footer, About Page, Loading Screen, and Documentation).

2. Application Brand: Student Management System

• Product Name: Student Management System
• Product Emblem: Custom modern vector SVG application logo (static/app-logo.svg) representing academic management, growth, and digital technology.
• Branding Architecture: Designed like leading enterprise software (e.g. VS Code by Microsoft → Student Management System by ADS Studio).

---

💻 Technologies Used

• Backend: Python 3, Flask (REST API)
• Database: SQLite3 (3NF Normalized)
• Frontend: HTML5, CSS3 (Glassmorphism UI), Vanilla JavaScript
• Architecture: Client-Server, RESTful API
• Design System: Custom CSS Grid/Flexbox with modern responsive layouts

---

✨ Features

• ⚡ Real-Time Dashboard Analytics: Automated calculation of total enrolled students, institutional average CGPA, and academic pass rates.
• 🎓 3NF Normalized Database: Built on a SQLite database normalized to Third Normal Form (3NF) separating personal and academic records.
• 🔍 Instant Live Search: Search across student names, PRNs, unique IDs, and email addresses.
• 🎛️ Advanced Filtering & Sorting: Filter by minimum CGPA score, course/department, and sort dynamically ascending or descending.
• 🛡️ Form Validation & UX Polish: Real-time field validation, toast notifications, confirmation modals, glassmorphism UI, and custom loading screen.
• 📱 Fully Responsive Layout: Built with modern CSS grid/flexbox and glassmorphism styling for mobile, tablet, and high-DPI displays.

---

🔗 Live Website: https://student-management-system-7if4.onrender.com

---

📸 Screenshots

📊 Dashboard

👨🎓 Student Directory

➕ Add Student

🔍 Search Students

🎯 Filter & Sort Records

ℹ️ About Page

---

📁 Folder Structure

Student Management System/
│
├── app.py                  # Main Flask REST API & SQLite controller
├── requirements.txt        # Python dependencies
├── students.db             # SQLite 3NF Database
├── README.md               # Product documentation & technical guide
├── .gitignore              # Git ignore configurations
│
├── templates/
│   └── index.html          # Main HTML5 SaaS application interface
│
└── static/
    ├── app-logo.svg        # Custom Application Logo (Vector SVG)
    ├── favicon.svg         # Application Browser Favicon
    ├── ads-studio-logo.jpg # Official ADS Studio Company Logo
    ├── style.css           # Premium SaaS CSS stylesheet & glassmorphism
    └── script.js           # Frontend REST client & reactive DOM handlers

---

🚀 Installation

Prerequisites

• Python 3.8 or higher
• pip (Python package manager)

Step-by-Step Guide

1. Clone or Download the Repository:

   git clone <repository-url>
   cd "Student Management System"

2. Activate Virtual Environment (Recommended):

   # On macOS / Linux
   python3 -m venv .venv
   source .venv/bin/activate
   
   # On Windows
   python -m venv .venv
   .venv\Scripts\activate

3. Install Dependencies:

   pip install -r requirements.txt

---

🏃 How to Run

1. Launch the Flask Server:

   python app.py

2. Access Application: Open a web browser and navigate to: http://localhost:5001 or http://127.0.0.1:5001.

---

🗄️ Database Architecture (3NF Normalization)

The database schema is strictly normalized into Third Normal Form (3NF) to eliminate redundancy and data anomalies:

1. students Table (Personal Information)

CREATE TABLE students (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    prn TEXT NOT NULL UNIQUE,
    age INTEGER NOT NULL,
    gender TEXT NOT NULL,
    email TEXT NOT NULL UNIQUE,
    phone TEXT NOT NULL
);

2. academic Table (Academic Information)

CREATE TABLE academic (
    academic_id INTEGER PRIMARY KEY AUTOINCREMENT,
    student_id INTEGER NOT NULL,
    course TEXT NOT NULL,
    semester INTEGER NOT NULL,
    cgpa REAL NOT NULL,
    FOREIGN KEY (student_id) REFERENCES students(id) ON DELETE CASCADE
);

---

📡 REST API Specifications

Method	Route	Description
GET	/	Serves main SaaS application UI
GET	/api/students	Retrieve all student records with JOIN query
GET	/api/students/<id>	Retrieve single student record details
POST	/api/students	Create new student & academic entry
PUT	/api/students/<id>	Update student personal & academic details
DELETE	/api/students/<id>	Delete student record (Cascades to academic)
GET	/api/students/search?q=query	Full-text search across records
GET	/api/students/filter?min_cgpa=X&course=Y	Filter students by criteria
GET	/api/students/sort?sort_by=cgpa&order=desc	Dynamic sorting endpoint
GET	/api/dashboard	Dashboard statistical summary

---

🔮 Future Improvements

• Authentication & Authorization: Add JWT-based login for administrator roles.
• Data Export: Add feature to export student data to CSV or Excel.
• Pagination: Implement server-side pagination for large datasets.
• Docker Support: Containerize the application for easier deployment.
• Enhanced Analytics: Add more charts and graphical representations of student performance.

---

📄 License

© 2026 ADS Studio. All Rights Reserved. Designed & Developed by ADS Studio.