How serena-fang/database-web-development-learning-management-system works
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: createdatabase.sql LMS database · qa.php Q&A and tags · homepage.php Student courses · authenticate.php Student sign-in
Components 17
Access and courses
- Student sign-in
HTML & PHP/authenticate.php - Staff sign-in
HTML & PHP/a2.php - Student courses
HTML & PHP/homepage.php - Staff courses
HTML & PHP/homepage2.php - LMS database
SQL/createdatabase.sql
Student learning
- Course grades
HTML & PHP/grade.php - Transcript
HTML & PHP/trans.php
Teaching tools
- Teaching course view
HTML & PHP/teach.php - Assignment creation
HTML & PHP/create.php - Grade entry form
HTML & PHP/igrade.php - Grade saving
HTML & PHP/g1.php
Course discussion
- Q&A and tags
HTML & PHP/qa.php - Tag filtering
HTML & PHP/tag2.php - Question posting
HTML & PHP/postc.php - Replies
HTML & PHP/reply1.php
Other components
- Student
- Instructor / TA
Connections 27
- Student → Student sign-in: signs in
README.md - Student sign-in → LMS database: checks identity
HTML & PHP/authenticate.php - Student sign-in → Student courses: redirects
HTML & PHP/authenticate.php - Instructor / TA → Staff sign-in: signs in
README.md - Staff sign-in → LMS database: checks identity
- Staff sign-in → Staff courses: redirects
- Student courses → LMS database: reads enrollments
HTML & PHP/homepage.php - Student courses → Course grades: opens details
HTML & PHP/homepage.php - Student courses → Transcript: opens transcript
HTML & PHP/homepage.php - Course grades → LMS database: reads grades
HTML & PHP/grade.php - Course grades → Q&A and tags: links Q&A
HTML & PHP/grade.php - Transcript → LMS database: reads course history
HTML & PHP/trans.php - Staff courses → LMS database: reads taught courses
HTML & PHP/homepage2.php - Staff courses → Teaching course view: opens course
HTML & PHP/homepage2.php - Teaching course view → LMS database: reads course grades
HTML & PHP/teach.php - Teaching course view → Assignment creation: submits assignment
HTML & PHP/teach.php - Assignment creation → LMS database: writes assignment
HTML & PHP/create.php - Assignment creation → Grade entry form: opens grading
HTML & PHP/create.php - Grade entry form → LMS database: reads enrolled students
HTML & PHP/igrade.php - Grade entry form → Grade saving: submits grades
HTML & PHP/igrade.php - Grade saving → LMS database: writes grades
HTML & PHP/g1.php - Q&A and tags → LMS database: reads posts and tags
HTML & PHP/qa.php - Q&A and tags → Tag filtering: submits tags
HTML & PHP/qa.php - Tag filtering → LMS database: filters posts
HTML & PHP/tag2.php - Q&A and tags → Question posting: submits question
HTML & PHP/qa.php - Question posting → LMS database: writes post
HTML & PHP/postc.php - Q&A and tags → Replies: opens reply
HTML & PHP/qa.php