# serena-fang/database-web-development-learning-management-system architecture

> Architecture diagram of the GitHub repository serena-fang/database-web-development-learning-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/serena-fang/database-web-development-learning-management-system
- Repository: https://github.com/serena-fang/database-web-development-learning-management-system

## Overview

This is a small PHP/MySQL learning-management web application for students and instructors/TAs. Students authenticate, view enrolled courses and grades, inspect assignment/course details, and use course Q&A to browse, filter, post, and reply. Instructors/TAs select a course, create assignments, and enter grades. The PHP pages query MySQL directly; the SQL scripts define and populate the database. The graph preserves documented transcript, tagging, reply, and grading capabilities, though some implementation details are unsampled.

Main entry points: [`SQL/createdatabase.sql`](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/SQL/createdatabase.sql) (LMS database), [`HTML & PHP/qa.php`](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/qa.php) (Q&A and tags), [`HTML & PHP/homepage.php`](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/homepage.php) (Student courses), [`HTML & PHP/authenticate.php`](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/authenticate.php) (Student sign-in)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_access["Access and courses"]
  node_student_auth["Student sign-in<br/>[authenticate.php]"]
  node_staff_auth["Staff sign-in<br/>[a2.php]"]
  node_student_home["Student courses<br/>[homepage.php]"]
  node_staff_home["Staff courses<br/>[homepage2.php]"]
  node_course_db[("LMS database<br/>[createdatabase.sql]")]
end

subgraph group_learning["Student learning"]
  node_course_grades["Course grades<br/>[grade.php]"]
  node_transcript["Transcript<br/>[trans.php]"]
end

subgraph group_teaching["Teaching tools"]
  node_course_teaching["Teaching course view<br/>[teach.php]"]
  node_assignment_create["Assignment creation<br/>[create.php]"]
  node_grade_entry["Grade entry form<br/>[igrade.php]"]
  node_grade_save["Grade saving<br/>[g1.php]"]
end

subgraph group_discussion["Course discussion"]
  node_qa_view["Q&amp;A and tags<br/>[qa.php]"]
  node_tag_filter["Tag filtering<br/>[tag2.php]"]
  node_post_create["Question posting<br/>[postc.php]"]
  node_reply_pages["Replies<br/>[reply1.php]"]
end

node_student(("Student"))
node_faculty(("Instructor / TA"))

node_student -->|"signs in"| node_student_auth
node_student_auth -->|"checks identity"| node_course_db
node_student_auth -->|"redirects"| node_student_home
node_faculty -->|"signs in"| node_staff_auth
node_staff_auth -.->|"checks identity"| node_course_db
node_staff_auth -.->|"redirects"| node_staff_home
node_student_home -->|"reads enrollments"| node_course_db
node_student_home -->|"opens details"| node_course_grades
node_student_home -->|"opens transcript"| node_transcript
node_course_grades -->|"reads grades"| node_course_db
node_course_grades -->|"links Q&amp;A"| node_qa_view
node_transcript -->|"reads course history"| node_course_db
node_staff_home -->|"reads taught courses"| node_course_db
node_staff_home -->|"opens course"| node_course_teaching
node_course_teaching -->|"reads course grades"| node_course_db
node_course_teaching -->|"submits assignment"| node_assignment_create
node_assignment_create -->|"writes assignment"| node_course_db
node_assignment_create -->|"opens grading"| node_grade_entry
node_grade_entry -->|"reads enrolled students"| node_course_db
node_grade_entry -->|"submits grades"| node_grade_save
node_grade_save -->|"writes grades"| node_course_db
node_qa_view -->|"reads posts and tags"| node_course_db
node_qa_view -->|"submits tags"| node_tag_filter
node_tag_filter -->|"filters posts"| node_course_db
node_qa_view -->|"submits question"| node_post_create
node_post_create -->|"writes post"| node_course_db
node_qa_view -->|"opens reply"| node_reply_pages

click node_student_auth "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/authenticate.php"
click node_staff_auth "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/a2.php"
click node_student_home "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/homepage.php"
click node_staff_home "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/homepage2.php"
click node_course_db "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/SQL/createdatabase.sql"
click node_course_grades "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/grade.php"
click node_transcript "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/trans.php"
click node_course_teaching "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/teach.php"
click node_assignment_create "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/create.php"
click node_grade_entry "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/igrade.php"
click node_grade_save "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/g1.php"
click node_qa_view "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/qa.php"
click node_tag_filter "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/tag2.php"
click node_post_create "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/postc.php"
click node_reply_pages "https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/reply1.php"

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_student_auth,node_staff_auth,node_student_home,node_staff_home,node_course_db toneBlue
class node_course_grades,node_transcript toneAmber
class node_course_teaching,node_assignment_create,node_grade_entry,node_grade_save toneMint
class node_qa_view,node_tag_filter,node_post_create,node_reply_pages toneRose
class node_student,node_faculty toneIndigo
```

## Components

### Access and courses

- [Student sign-in](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/authenticate.php): `HTML & PHP/authenticate.php`
- [Staff sign-in](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/a2.php): `HTML & PHP/a2.php`
- [Student courses](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/homepage.php): `HTML & PHP/homepage.php`
- [Staff courses](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/homepage2.php): `HTML & PHP/homepage2.php`
- [LMS database](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/SQL/createdatabase.sql): `SQL/createdatabase.sql`

### Student learning

- [Course grades](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/grade.php): `HTML & PHP/grade.php`
- [Transcript](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/trans.php): `HTML & PHP/trans.php`

### Teaching tools

- [Teaching course view](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/teach.php): `HTML & PHP/teach.php`
- [Assignment creation](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/create.php): `HTML & PHP/create.php`
- [Grade entry form](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/igrade.php): `HTML & PHP/igrade.php`
- [Grade saving](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/g1.php): `HTML & PHP/g1.php`

### Course discussion

- [Q&A and tags](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/qa.php): `HTML & PHP/qa.php`
- [Tag filtering](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/tag2.php): `HTML & PHP/tag2.php`
- [Question posting](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/postc.php): `HTML & PHP/postc.php`
- [Replies](https://github.com/serena-fang/database-web-development-learning-management-system/blob/main/HTML%20%26%20PHP/reply1.php): `HTML & PHP/reply1.php`

### Other components

- **Student**
- **Instructor / TA**

## Connections

- Student → Student sign-in: signs in (evidence: `README.md`)
- Student sign-in → LMS database: checks identity (evidence: `HTML & PHP/authenticate.php`)
- Student sign-in → Student courses: redirects (evidence: `HTML & PHP/authenticate.php`)
- Instructor / TA → Staff sign-in: signs in (evidence: `README.md`)
- Staff sign-in → LMS database: checks identity
- Staff sign-in → Staff courses: redirects
- Student courses → LMS database: reads enrollments (evidence: `HTML & PHP/homepage.php`)
- Student courses → Course grades: opens details (evidence: `HTML & PHP/homepage.php`)
- Student courses → Transcript: opens transcript (evidence: `HTML & PHP/homepage.php`)
- Course grades → LMS database: reads grades (evidence: `HTML & PHP/grade.php`)
- Course grades → Q&A and tags: links Q&A (evidence: `HTML & PHP/grade.php`)
- Transcript → LMS database: reads course history (evidence: `HTML & PHP/trans.php`)
- Staff courses → LMS database: reads taught courses (evidence: `HTML & PHP/homepage2.php`)
- Staff courses → Teaching course view: opens course (evidence: `HTML & PHP/homepage2.php`)
- Teaching course view → LMS database: reads course grades (evidence: `HTML & PHP/teach.php`)
- Teaching course view → Assignment creation: submits assignment (evidence: `HTML & PHP/teach.php`)
- Assignment creation → LMS database: writes assignment (evidence: `HTML & PHP/create.php`)
- Assignment creation → Grade entry form: opens grading (evidence: `HTML & PHP/create.php`)
- Grade entry form → LMS database: reads enrolled students (evidence: `HTML & PHP/igrade.php`)
- Grade entry form → Grade saving: submits grades (evidence: `HTML & PHP/igrade.php`)
- Grade saving → LMS database: writes grades (evidence: `HTML & PHP/g1.php`)
- Q&A and tags → LMS database: reads posts and tags (evidence: `HTML & PHP/qa.php`)
- Q&A and tags → Tag filtering: submits tags (evidence: `HTML & PHP/qa.php`)
- Tag filtering → LMS database: filters posts (evidence: `HTML & PHP/tag2.php`)
- Q&A and tags → Question posting: submits question (evidence: `HTML & PHP/qa.php`)
- Question posting → LMS database: writes post (evidence: `HTML & PHP/postc.php`)
- Q&A and tags → Replies: opens reply (evidence: `HTML & PHP/qa.php`)
