Giter Club home page Giter Club logo

advanced-student-management-system's Introduction

Student Management System with MySQL Database

The Student Management System (SMS) is a GUI application created with Python and tkinter. It is designed to manage student data for a school or university. This version of the system utilizes a MySQL database to store and retrieve student information, such as names, addresses, contact information, and academic records.

Student Management System

Features

  • Add new students to the system
  • Edit existing student information
  • Delete students from the system
  • View a list of all students in the system
  • Search for a specific student by name or ID
  • Export student data to a CSV file

Installation

  1. Clone this repository to your local machine.
  2. Install the required dependencies using
    pip install pip install pillow mysql-connector-python
  3. Create a MySQL database and import the sms.sql file to create the necessary tables.
  4. Modify the config.ini file to include your MySQL database credentials.
  5. Run the student.py file to launch the application.

Usage

Upon launching the application, you will be presented with a GUI window that displays a list of all students in the system. From there, you can perform various actions on the student data using the buttons and fields provided.

Adding a new student

To add a new student, click the "Add Student" button and fill out the required fields in the form that appears. Once you have entered all the necessary information, click "Save" to add the new student to the system.

Editing a student

To edit an existing student's information, select the student from the list and click the "Edit Student" button. This will bring up the same form used for adding a new student, but with the fields pre-filled with the student's current information. Make any necessary changes and click "Save" to update the student's data.

Deleting a student

To delete a student from the system, select the student from the list and click the "Delete Student" button. You will be prompted to confirm the deletion before the student is removed from the system.

Searching for a student

To search for a specific student, enter the student's name or ID in the search field at the top of the window and click "Search". The list of students will be filtered to show only those that match your search criteria.

Exporting student data

To export the student data to a CSV file, click the "Export to CSV" button. The file will be saved in the same directory as the application.

Contributing

If you find a bug or would like to suggest a new feature, please open an issue or submit a pull request on GitHub. Contributions are always welcome!

advanced-student-management-system's People

Contributors

alok-2002 avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar

Forkers

dbg333

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.