student-management-system

A command-line Student Management System built using Python and SQLite. This project allows users to manage student records with features such as adding, updating, deleting, searching, sorting, statistics, and CSV import/export.

---

Features

Student Management

• Add Student
• View All Students
• Search Student by Name
• Update Student Details
• Update Student Name
• Delete Student

Search Features

• Search by Exact Name
• Partial Name Search
• Prefix Name Search
• Search by Course
• Search by Age Range
• Search by Age and Course
• Search by Age or Course
• Search by Course and Age Range

Statistics

• Count Total Students
• Average Age
• Maximum Age
• Minimum Age
• Total Age
• Show Available Courses
• Students by Course
• Popular Courses

Sorting and Pagination

• Sort Students by Age
• Sort Students by Course and Age
• Top N Oldest Students
• Top N Youngest Students
• Pagination using LIMIT and OFFSET

CSV Support

• Export Students to CSV
• Import Students from CSV

Input Validation

• Empty input validation
• Numeric input validation
• Invalid menu choice handling
• Age range validation

---

Technologies Used

• Python 3
• SQLite3
• CSV Module
• Git
• GitHub

---

Project Structure

student-management-system/
│
├── main.py
├── database.py
├── student.db
├── students.csv
└── README.md

---

How to Run

Clone the repository:

git clone https://github.com/vikash-kun/student-management-system.git

Move into the project directory:

cd student-management-system

Run the program:

python main.py

---

SQL Concepts Used

• CREATE TABLE
• INSERT
• SELECT
• UPDATE
• DELETE
• WHERE
• AND
• OR
• BETWEEN
• LIKE
• DISTINCT
• ORDER BY
• GROUP BY
• COUNT()
• AVG()
• MIN()
• MAX()
• SUM()
• LIMIT
• OFFSET

---

Python Concepts Used

• Functions
• Modules
• Exception Handling
• Loops
• Conditional Statements
• File Handling
• CSV Reader
• CSV Writer
• SQLite Database Connectivity
• Input Validation

---

Learning Outcomes

This project helped me learn:

• Building a complete CRUD application
• Working with SQLite databases
• Executing SQL queries from Python
• Importing and exporting CSV files
• Organizing code into multiple modules
• Using Git and GitHub for version control
• Writing clean and reusable Python functions

---

Sample Menu

========== Student Management System ==========
1. Add Student
2. View Students
3. Search Student
4. Update Student
5. Delete Student
6. Sort Students by Age
7. Count Students
8. Search by Age and Course
9. Search by Age OR Course
10. Partial Name Search
11. Average Age
12. Maximum Age
13. Minimum Age
14. Show Available Courses
15. Students by Course
16. Popular Courses
17. Top N Oldest Students
18. Show Students (Pagination)
19. Sort Students by Course and Age
20. Update Student Name
21. Search Students by Age Range
22. Search by Course
23. Top N Youngest Students
24. Export Students to CSV
25. Import Students from CSV
26. Search Name Prefix
27. Search by Course and Age Range
28. Exit

---

Future Improvements

• Graphical User Interface (Tkinter or PyQt)
• User Authentication
• Student Attendance Management
• Marks and Grade Management
• Backup and Restore Database
• Data Visualization using Matplotlib
• Flask or Django Web Version
• REST API Integration

---

Author

Vikash