This is a Python program for managing student information in a student database. It provides various functionalities such as registering a new student, searching for a student, updating student information, deleting a student, counting the total number of students, counting the number of males and females, displaying the top-scoring student for each department, displaying the top-scoring female student for each department, listing students who scored above a given GPA, showing frequent student names, and displaying the total number of students in each department.
- Run the
Main.py
file. - Choose an option from the menu to perform the desired operation.
- Follow the prompts and provide the necessary information.
-
Register a New Student: Allows you to register a new student by providing their full name, gender, ID, department, and CGPA.
-
Search for Student: Allows you to search for a student by their ID and displays their information if found.
-
Update Student Name: Allows you to update the name of a student by providing their ID and the new name.
-
Update Student GPA: Allows you to update the CGPA of a student by providing their ID and the new CGPA.
-
Delete Student by ID: Allows you to delete a student from the database by providing their ID.
-
Count and Display Total Number of Students: Counts and displays the total number of students in the database.
-
Count Total Number of Males and Females in the Students: Counts and displays the total number of males and females in the database.
-
Display Name and Department of Top Scored Student for Each Department: Displays the name and department of the top-scoring student for each department.
-
Display Name and Department of Top Scored Female Student for Each Department: Displays the name and department of the top-scoring female student for each department.
-
List Names of the Students Who Scored Given GPA: Lists the names of the students who scored above a given GPA.
-
Show Frequent Student Names: Shows the names of the students that occur frequently in the database.
-
Show Total Number of Students in Each Department: Displays the total number of students in each department.
-
Exit: Exits the program.
- this file can be used by default if not changed
- Python 3.x
1 tajudin ahmed jama id 1403049
2 yabsira haile serbesa id 1405091
3 hashim farah aden id 1405054
4 yosef mulugeta dema id 1403303
5 firaol arebu aliy id 1401968