Student-Management-System

A Python menu driven project which stores data of students in My SQL.

The user can enter the records of students and store them in a database called Sqlite3 which is in an essence the online version of My SQL database. The program also allows user various operations to the database like modification, addition, deletion etc.

Warning

This project was created on Google Colab and hence may not work properly when run locally on the machine. Also this project stores the database file in Google Drive. Hence, it is recommended to run the Python script in Google Colab only.

Features

1. Insert Records.
2. Display Records.
3. Modify Records.
4. Search Records.
5. Delete Records.
6. Display deleted records.

Fields user can enter in the database

1. Name of student.
2. Age.
3. Roll number.
4. Gender (Male/ Female) (Sorry LBGTQ guys).
5. Phone number.
6. Marks (out of 100) of 5 subjects (English, Chemistry, Physics, Maths and Computer Science) .

Thanks for trying out this little project of mine. :)