How iswarya2025n/mysql-project01-python-mysql works
This is a small command-line student management system. A user selects an operation in the menu; the corresponding handler prompts for student details, uses a MySQL connection to perform an insert, list, grade update, or delete, and prints the result. The single source file contains both the menu and handlers, so the graph separates their responsibilities without implying separate modules. Evidence is limited to the supplied ums.py excerpt; no README or other product capabilities were provided.
Main entry points: ums.py Operation menu
Components 8
Command-line workflow
- Operation menu
ums.py - Connection helper
ums.py
Student records
- Add student
ums.py - View students
ums.py - Update grade
ums.py - Delete student
ums.py
Other components
- User
- MySQL database
Connections 14
- User → Operation menu: selects action
ums.py - Operation menu → Add student: dispatches
ums.py - Operation menu → View students: dispatches
ums.py - Operation menu → Update grade: dispatches
ums.py - Operation menu → Delete student: dispatches
ums.py - Add student → Connection helper: opens connection
ums.py - View students → Connection helper: opens connection
ums.py - Update grade → Connection helper: opens connection
ums.py - Delete student → Connection helper: opens connection
ums.py - Connection helper → MySQL database: connects to
ums.py - Add student → MySQL database: inserts record
ums.py - View students → MySQL database: reads records
ums.py - Update grade → MySQL database: updates grade
ums.py - Delete student → MySQL database: deletes record
ums.py