# tech-voyager1/cit-faculty-management-system architecture

> Architecture diagram of the GitHub repository tech-voyager1/cit-faculty-management-system, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/tech-voyager1/cit-faculty-management-system
- Repository: https://github.com/tech-voyager1/cit-faculty-management-system

## Overview

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`](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py) (Desktop application), [`db.py`](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/db.py) (Faculty data access), [`setup_database.py`](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/setup_database.py) (Database initializer), [`db_logger.py`](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/db_logger.py) (SQL event logger)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_desktop["Desktop interface"]
  node_app["Desktop application<br/>[main.py]"]
  node_dashboard["Summary dashboard<br/>[main.py]"]
  node_directory["Faculty directory<br/>[main.py]"]
  node_profile["Joined profiles<br/>[main.py]"]
  node_record_editor["Record editor<br/>[main.py]"]
  node_query_builder["Advanced query<br/>[main.py]"]
  node_sql_monitor["Live SQL monitor<br/>[main.py]"]
end

subgraph group_services["Application services"]
  node_data_access["Faculty data access<br/>[db.py]"]
  node_sql_logger["SQL event logger<br/>[db_logger.py]"]
end

subgraph group_database["Database"]
  node_mysql[("MySQL server")]
  node_faculty_tables[("Faculty tables<br/>[schema.sql]")]
end

subgraph group_setup["Database setup"]
  node_initializer["Database initializer<br/>[setup_database.py]"]
  node_gui_initializer["GUI initializer"]
  node_seed_data["Seed records<br/>[seed.sql]"]
end

node_faculty_user(("Faculty administrator"))

node_faculty_user -->|"uses"| node_app
node_app -->|"shows"| node_dashboard
node_app -->|"shows"| node_directory
node_app -->|"opens"| node_profile
node_app -->|"opens"| node_record_editor
node_app -->|"offers"| node_query_builder
node_app -->|"offers"| node_sql_monitor
node_dashboard -->|"fetches counts"| node_data_access
node_directory -->|"searches"| node_data_access
node_profile -->|"fetches joined data"| node_data_access
node_record_editor -->|"writes records"| node_data_access
node_query_builder -->|"runs queries"| node_data_access
node_sql_monitor -.->|"displays activity"| node_sql_logger
node_data_access -->|"queries and updates"| node_mysql
node_data_access -->|"notifies SQL"| node_sql_logger
node_mysql -->|"stores records"| node_faculty_tables
node_initializer -->|"creates schema"| node_mysql
node_initializer -->|"loads records"| node_seed_data
node_initializer -->|"executes DDL"| node_faculty_tables
node_gui_initializer -->|"creates database"| node_mysql

click node_app "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py"
click node_dashboard "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py"
click node_directory "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py"
click node_profile "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py"
click node_record_editor "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py"
click node_query_builder "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py"
click node_sql_monitor "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py"
click node_data_access "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/db.py"
click node_sql_logger "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/db_logger.py"
click node_faculty_tables "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/database/schema.sql"
click node_initializer "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/setup_database.py"
click node_gui_initializer "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/setup_database_gui.py"
click node_seed_data "https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/database/seed.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_app,node_dashboard,node_directory,node_profile,node_record_editor,node_query_builder,node_sql_monitor toneBlue
class node_data_access,node_sql_logger toneAmber
class node_mysql,node_faculty_tables toneMint
class node_initializer,node_gui_initializer,node_seed_data toneRose
class node_faculty_user toneIndigo
```

## Components

### Desktop interface

- [Desktop application](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py): `main.py`
- [Summary dashboard](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py): `main.py`
- [Faculty directory](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py): `main.py`
- [Joined profiles](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py): `main.py`
- [Record editor](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py): `main.py`
- [Advanced query](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py): `main.py`
- [Live SQL monitor](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/main.py): `main.py`

### Application services

- [Faculty data access](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/db.py): `db.py`
- [SQL event logger](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/db_logger.py): `db_logger.py`

### Database

- **MySQL server**
- [Faculty tables](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/database/schema.sql): `database/schema.sql`

### Database setup

- [Database initializer](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/setup_database.py): `setup_database.py`
- [GUI initializer](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/setup_database_gui.py): `setup_database_gui.py`
- [Seed records](https://github.com/tech-voyager1/cit-faculty-management-system/blob/main/database/seed.sql): `database/seed.sql`

### Other components

- **Faculty administrator**

## Connections

- Faculty administrator → Desktop application: uses (evidence: `README.md`)
- Desktop application → Summary dashboard: shows (evidence: `main.py`)
- Desktop application → Faculty directory: shows (evidence: `README.md`)
- Desktop application → Joined profiles: opens (evidence: `main.py`)
- Desktop application → Record editor: opens (evidence: `main.py`)
- Desktop application → Advanced query: offers (evidence: `README.md`)
- Desktop application → Live SQL monitor: offers (evidence: `main.py`)
- Summary dashboard → Faculty data access: fetches counts (evidence: `main.py`)
- Faculty directory → Faculty data access: searches (evidence: `README.md`)
- Joined profiles → Faculty data access: fetches joined data (evidence: `main.py`)
- Record editor → Faculty data access: writes records (evidence: `README.md`)
- Advanced query → Faculty data access: runs queries (evidence: `README.md`)
- Live SQL monitor → SQL event logger: displays activity (evidence: `main.py`)
- Faculty data access → MySQL server: queries and updates (evidence: `README.md`)
- Faculty data access → SQL event logger: notifies SQL (evidence: `db.py`)
- MySQL server → Faculty tables: stores records (evidence: `README.md`)
- Database initializer → MySQL server: creates schema (evidence: `setup_database.py`)
- Database initializer → Seed records: loads records (evidence: `setup_database.py`)
- Database initializer → Faculty tables: executes DDL (evidence: `setup_database.py`)
- GUI initializer → MySQL server: creates database (evidence: `setup_database_gui.py`)
