College Student Management System 🎓

A robust GUI-based desktop application developed using Python (Tkinter) and SQLite3 (with optional support for MySQL), enabling colleges to manage student records efficiently. The system follows a modular and scalable structure with a clean UI, validation layers, and export features.

---

🔧 Tech Stack

• Frontend (GUI): Tkinter, ttk, tkcalendar
• Backend (DB Layer): SQLite (default), MySQL (optional)
• Languages Used: Python 3
• Modules/Libraries: sqlite3, tkcalendar, re, csv, datetime

---

💼 Key Features

• Add, Update, Delete Student Records
• View & Search Records by ID/Name
• Input Validation (Email, Phone)
• DOB Picker Integration
• Export Records to CSV
• Responsive TreeView Table
• Modern UI with Color Themes
• Extensible for MySQL Integration

---

✅ Project Highlights (Job Description Alignment)

• 🔄 Full SDLC Implementation: Covers all stages — from requirement analysis, GUI design, development, testing, and deployment.
• 📦 Reusable Codebase: Follows modular practices with encapsulated methods (add_record(), update_record(), search_record(), etc.)
• 💡 Strong OOP Principles: Class-based architecture with proper method abstractions.
• ⚙️ Hands-on with DB Integration: Supports both SQLite3 and MySQL with CRUD operations and optional schema migration.
• 🖼️ Frontend & Design Patterns: Uses structured layouts and conditional logic to manage UI states — akin to event-driven architecture.
• 🧪 Validation & Error Handling: Regex-based email checks, number validation, and try-except blocks for fault-tolerance.
• 📤 Data Export: Ability to generate clean CSV reports — useful for BI pipelines or reports.
• 🖥️ Designed for Windows OS: Fully functional on Windows environments, following Microsoft GUI principles.

---

🚀 Getting Started

1. Clone the repository:

   git clone [https://github.com/pragya79/College-Student-Record-Management-System.git]
   cd college-management-system

2. Install Dependencies:

   pip install tkcalendar

3. Run Application:

   python main.py