-
Install MySQL Python Connector:
- Ensure MySQL is installed.
- Install MySQL Python Connector by running:
pip install mysql-connector-python
.
-
Install the "fake" library:
- Run:
pip install fake
to install the fake library.
- Run:
-
Implement the
Student
class to represent student records with attributes for roll number, name, and percentage. -
Create methods for adding a record, displaying a record, modifying a record, and displaying a formatted record within the
Student
class. -
Set up file handling:
- Import the
pickle
module for serializing and deserializing Python objects to/from a binary file. - Import the
os
module for file and directory manipulation.
- Import the
-
Implement a Main Menu Loop:
- Create a main menu for user interaction using a while loop.
- Allow users to choose from options to add, display, search, modify, or delete student records.
- Ensure the loop continues until the user selects the "Exit" option.
-
Implement Data Storage:
- Store records of student objects in a binary file named "stud.dat."
- Add records to the file using the "Add record" option.
-
Implement Displaying Records:
- Implement the "Display all records" option to read and display all records stored in "stud.dat."
-
Implement Searching Records:
- Implement the "Search by roll number" and "Search by name" options to find records based on roll number or name.
- Display found records if they exist.
-
Implement Modifying Records:
- Implement the "Modify by roll number" option to allow users to change data (roll number, name, percentage) of an existing record.
-
Implement Deleting Records:
- Implement the "Delete by roll number" option to allow users to delete a record based on the roll number.
-
Add Error Handling:
- Implement basic error handling, especially for file-related exceptions.
-
Clear Console Screen:
- Utilize
os.system("cls")
to clear the console screen for better user interaction (Windows specific).
- Utilize
- Document deployment steps in the README for users to easily deploy the project.
- Ensure all Python files (
.py
) are included for running the project.