🎬 Demo

Interactive walkthrough showing student and lecturer CRUD operations, responsive navigation, and database management features.

🎯 Project Overview

Converted original Tkinter desktop application into a modern responsive web application for SSX361 project. Implemented complete educational management system featuring full CRUD operations for students and lecturers, utilizing Flask backend with SQLite database and Bootstrap 5 frontend with glassmorphism design.

🏗️ Architecture Highlights

  • Flask 3.0 backend with modular CRUD operation handlers
  • SQLite3 database with normalized schema for students and lecturers
  • Bootstrap 5 responsive UI with glassmorphism theme and mobile-first design
  • Jinja2 templating engine with dynamic navbar active states
  • Modular business logic structure (Create, Read, Update, Delete modules)
  • Production deployment configuration for PythonAnywhere hosting
  • Pillow image processing integration for logo and static assets

📊 Features & Capabilities

  • Full CRUD operations for student records (ID, first name, last name, student number)
  • Full CRUD operations for lecturer records (employee ID, names, course assignment)
  • Responsive navigation with dynamic active states and hover animations
  • Glassmorphism design system with card shadows and form validation styling
  • Database initialization endpoint with sample data generation
  • Sticky table headers for improved data browsing experience
  • Flash message system for operation feedback
  • Static file serving for CSS themes and image assets