| 1 | | User (**id_user**, username, password, email, created_at) |
| 2 | | Administration (department) |
| 3 | | Teacher (id_teacher, hire_date, department) |
| 4 | | Rating (id_rating, rating, explanation, id_teacher) |
| 5 | | Subject (id_subject, name, description) |
| 6 | | Course (id_Course, num_of_classes, created_by) |
| 7 | | Class (id_class, start_time, end_time, duration, teacher_id) |
| 8 | | Student (id_student, progress_score) |
| 9 | | Enrollment (id_enrollment, id_student, id_Course, status, en_date) |
| 10 | | Assignment (id_assignment, description, score, deadline) |
| 11 | | Submission (id_submission, id_student, id_assignment, submitted_at, progress_score) |
| 12 | | Attendance (id_attendance, id_student, id_class, attended) |
| 13 | | Subject_Course (id_subject, id_Course) |
| 14 | | Course_Assignment (id_Course, id_assignment) |
| 15 | | Course_Class (id_Course, id_class) |
| | 1 | = Database Schema = |
| | 2 | |
| | 3 | == User == |
| | 4 | * '''id_user''' – Primary Key |
| | 5 | * username |
| | 6 | * password |
| | 7 | * email |
| | 8 | * created_at |
| | 9 | |
| | 10 | == Administration == |
| | 11 | * '''id_user*''' – Foreign Key |
| | 12 | * department |
| | 13 | |
| | 14 | == Teacher == |
| | 15 | * '''id_user*''' – Foreign Key |
| | 16 | * '''id_teacher''' – Primary Key |
| | 17 | * hire_date |
| | 18 | * department |
| | 19 | |
| | 20 | == Rating == |
| | 21 | * '''id_rating''' – Primary Key |
| | 22 | * rating |
| | 23 | * explanation |
| | 24 | * '''id_teacher*''' – Foreign Key |
| | 25 | * '''id_student*''' – Foreign Key |
| | 26 | |
| | 27 | == Subject == |
| | 28 | * '''id_subject''' – Primary Key |
| | 29 | * name |
| | 30 | * description |
| | 31 | |
| | 32 | == Course == |
| | 33 | * '''id_Course''' – Primary Key |
| | 34 | * num_of_classes |
| | 35 | * created_by |
| | 36 | |
| | 37 | == Class == |
| | 38 | * '''id_class''' – Primary Key |
| | 39 | * start_time |
| | 40 | * end_time |
| | 41 | * duration |
| | 42 | * '''teacher_id*''' – Foreign Key |
| | 43 | * '''id_attendance*''' – Foreign Key |
| | 44 | |
| | 45 | == Student == |
| | 46 | * '''id_student''' – Primary Key |
| | 47 | * progress_score |
| | 48 | |
| | 49 | == Assignment == |
| | 50 | * '''id_assignment''' – Primary Key |
| | 51 | * description |
| | 52 | * score |
| | 53 | * deadline |
| | 54 | |
| | 55 | == Enrollment == |
| | 56 | * '''id_enrollment*''' – Primary Key |
| | 57 | * '''id_student*''' – Foreign Key |
| | 58 | * '''id_Course*''' – Foreign Key |
| | 59 | * status |
| | 60 | * en_date |
| | 61 | |
| | 62 | == Submission == |
| | 63 | * '''id_submission*''' – Primary Key |
| | 64 | * '''id_student*''' – Foreign Key |
| | 65 | * '''id_assignment*''' – Foreign Key |
| | 66 | * submitted_at |
| | 67 | * progress_score |
| | 68 | |
| | 69 | == Attendance == |
| | 70 | * '''id_attendance''' – Primary Key |
| | 71 | * '''id_student*''' – Foreign Key |
| | 72 | * '''id_class*''' – Foreign Key |
| | 73 | * attended |
| | 74 | |
| | 75 | == Subject_Course == |
| | 76 | * '''id_subject*''' – Foreign Key |
| | 77 | * '''id_Course*''' – Foreign Key |
| | 78 | |
| | 79 | == Course_Assignment == |
| | 80 | * '''id_Course*''' – Foreign Key |
| | 81 | * '''id_assignment*''' – Foreign Key |
| | 82 | |
| | 83 | == Course_Class == |
| | 84 | * '''id_Course''' – Primary Key |
| | 85 | * '''id_class''' – Primary Key |
