# leilibrk/learning-management-system-database-design architecture

> Architecture diagram of the GitHub repository leilibrk/learning-management-system-database-design, 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/leilibrk/learning-management-system-database-design
- Repository: https://github.com/leilibrk/learning-management-system-database-design

## Overview

This is a small Python/MySQL LMS coursework project. Students and professors use a console workflow: authenticate, then access role-specific course, assessment, and grading actions; the Python client invokes MySQL stored procedures and displays their results. The README documents enrollment and course-data design, while the SQL file is not excerpted, so its internal schema relationships cannot be detailed here.

Main entry points: [`main.py`](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py) (Professor actions), [`console.sql`](https://github.com/leilibrk/learning-management-system-database-design/blob/master/console.sql) (MySQL database)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_client["Python client"]
  node_console["Console app<br/>[main.py]"]
  node_authentication["Authentication<br/>[main.py]"]
  node_student_menu["Student actions<br/>[main.py]"]
  node_professor_menu["Professor actions<br/>[main.py]"]
end

subgraph group_lms["LMS capabilities"]
  node_courses["Courses and enrollment<br/>[console.sql]"]
  node_exam_setup["Exam authoring<br/>[main.py]"]
  node_exam_work["Exam participation<br/>[main.py]"]
  node_homework_setup["Homework authoring<br/>[main.py]"]
  node_homework_work["Homework submissions<br/>[main.py]"]
  node_review_grading["Review and grading<br/>[main.py]"]
end

subgraph group_storage["Database"]
  node_mysql[("MySQL database<br/>[console.sql]")]
end

node_student(("Student"))
node_professor(("Professor"))

node_student -->|"uses"| node_console
node_professor -->|"uses"| node_console
node_console -->|"authenticates"| node_authentication
node_authentication -->|"calls login"| node_mysql
node_console -->|"routes students"| node_student_menu
node_console -->|"routes professors"| node_professor_menu
node_student_menu -->|"views courses"| node_courses
node_professor_menu -->|"views students"| node_courses
node_student_menu -->|"takes exams"| node_exam_work
node_student_menu -->|"submits homework"| node_homework_work
node_professor_menu -->|"defines exams"| node_exam_setup
node_professor_menu -->|"defines homework"| node_homework_setup
node_professor_menu -->|"reviews and grades"| node_review_grading
node_student_menu -->|"calls procedures"| node_mysql
node_professor_menu -->|"calls procedures"| node_mysql

click node_console "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_authentication "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_student_menu "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_professor_menu "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_courses "https://github.com/leilibrk/learning-management-system-database-design/blob/master/console.sql"
click node_exam_setup "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_exam_work "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_homework_setup "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_homework_work "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_review_grading "https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py"
click node_mysql "https://github.com/leilibrk/learning-management-system-database-design/blob/master/console.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_console,node_authentication,node_student_menu,node_professor_menu toneBlue
class node_courses,node_exam_setup,node_exam_work,node_homework_setup,node_homework_work,node_review_grading toneAmber
class node_mysql toneMint
class node_student,node_professor toneIndigo
```

## Components

### Python client

- [Console app](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`
- [Authentication](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`
- [Student actions](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`
- [Professor actions](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`

### LMS capabilities

- [Courses and enrollment](https://github.com/leilibrk/learning-management-system-database-design/blob/master/console.sql): `console.sql`
- [Exam authoring](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`
- [Exam participation](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`
- [Homework authoring](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`
- [Homework submissions](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`
- [Review and grading](https://github.com/leilibrk/learning-management-system-database-design/blob/master/main.py): `main.py`

### Database

- [MySQL database](https://github.com/leilibrk/learning-management-system-database-design/blob/master/console.sql): `console.sql`

### Other components

- **Student**
- **Professor**

## Connections

- Student → Console app: uses (evidence: `README.md`)
- Professor → Console app: uses (evidence: `README.md`)
- Console app → Authentication: authenticates (evidence: `main.py`)
- Authentication → MySQL database: calls login (evidence: `main.py`)
- Console app → Student actions: routes students (evidence: `main.py`)
- Console app → Professor actions: routes professors (evidence: `main.py`)
- Student actions → Courses and enrollment: views courses (evidence: `main.py`)
- Professor actions → Courses and enrollment: views students (evidence: `main.py`)
- Student actions → Exam participation: takes exams (evidence: `main.py`)
- Student actions → Homework submissions: submits homework (evidence: `main.py`)
- Professor actions → Exam authoring: defines exams (evidence: `main.py`)
- Professor actions → Homework authoring: defines homework (evidence: `main.py`)
- Professor actions → Review and grading: reviews and grades (evidence: `main.py`)
- Student actions → MySQL database: calls procedures (evidence: `main.py`)
- Professor actions → MySQL database: calls procedures (evidence: `main.py`)
