How tech-voyager1/cit-faculty-management-system works
CIT Faculty Management is a Tkinter desktop application for administering faculty and academic records in MySQL. Users browse dashboard counts and a searchable directory, inspect joined profiles, and manage records; the README also documents a relational query builder and live SQL monitor. The GUI delegates database operations to db.py, which records SQL activity through db_logger.py. MySQL is initialized by the command-line setup flow, with a separate GUI installer also present. Some GUI and database implementation details were not sampled; documented features are retained without asserting unverified call paths.
Main entry points: main.py Desktop application · db.py Faculty data access · setup_database.py Database initializer · db_logger.py SQL event logger
Components 15
Desktop interface
- Desktop application
main.py - Summary dashboard
main.py - Faculty directory
main.py - Joined profiles
main.py - Record editor
main.py - Advanced query
main.py - Live SQL monitor
main.py
Application services
- Faculty data access
db.py - SQL event logger
db_logger.py
Database
- MySQL server
- Faculty tables
database/schema.sql
Database setup
- Database initializer
setup_database.py - GUI initializer
setup_database_gui.py - Seed records
database/seed.sql
Other components
- Faculty administrator
Connections 20
- Faculty administrator → Desktop application: uses
README.md - Desktop application → Summary dashboard: shows
main.py - Desktop application → Faculty directory: shows
README.md - Desktop application → Joined profiles: opens
main.py - Desktop application → Record editor: opens
main.py - Desktop application → Advanced query: offers
README.md - Desktop application → Live SQL monitor: offers
main.py - Summary dashboard → Faculty data access: fetches counts
main.py - Faculty directory → Faculty data access: searches
README.md - Joined profiles → Faculty data access: fetches joined data
main.py - Record editor → Faculty data access: writes records
README.md - Advanced query → Faculty data access: runs queries
README.md - Live SQL monitor → SQL event logger: displays activity
main.py - Faculty data access → MySQL server: queries and updates
README.md - Faculty data access → SQL event logger: notifies SQL
db.py - MySQL server → Faculty tables: stores records
README.md - Database initializer → MySQL server: creates schema
setup_database.py - Database initializer → Seed records: loads records
setup_database.py - Database initializer → Faculty tables: executes DDL
setup_database.py - GUI initializer → MySQL server: creates database
setup_database_gui.py