Changes between Version 3 and Version 4 of Relational schema (DDL and Database)
- Timestamp:
- 02/05/25 22:30:26 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Relational schema (DDL and Database)
v3 v4 2 2 3 3 = Entities = 4 == User==4 === User === 5 5 * '''id_user''' – Primary Key 6 6 * username … … 9 9 * created_at 10 10 11 == Administration==11 === Administration === 12 12 * '''id_user*''' – Foreign Key 13 13 * department 14 14 15 == Teacher==15 === Teacher === 16 16 * '''id_user*''' – Foreign Key 17 17 * '''id_teacher''' – Primary Key … … 19 19 * department 20 20 21 == Rating==21 === Rating === 22 22 * '''id_rating''' – Primary Key 23 23 * rating … … 26 26 * '''id_student*''' – Foreign Key 27 27 28 == Subject==28 === Subject === 29 29 * '''id_subject''' – Primary Key 30 30 * name 31 31 * description 32 32 33 == Course==33 === Course === 34 34 * '''id_Course''' – Primary Key 35 35 * num_of_classes 36 36 * created_by 37 37 38 == Class==38 === Class === 39 39 * '''id_class''' – Primary Key 40 40 * start_time … … 44 44 * '''id_attendance*''' – Foreign Key 45 45 46 == Student==46 === Student === 47 47 * '''id_student''' – Primary Key 48 48 * progress_score 49 49 50 == Assignment==50 === Assignment === 51 51 * '''id_assignment''' – Primary Key 52 52 * description … … 54 54 * deadline 55 55 56 = Relations=56 == Relations == 57 57 58 == Enrollment==58 === Enrollment === 59 59 * '''id_enrollment*''' – Primary Key 60 60 * '''id_student*''' – Foreign Key … … 63 63 * en_date 64 64 65 == Submission==65 === Submission === 66 66 * '''id_submission*''' – Primary Key 67 67 * '''id_student*''' – Foreign Key … … 70 70 * progress_score 71 71 72 == Attendance==72 === Attendance === 73 73 * '''id_attendance''' – Primary Key 74 74 * '''id_student*''' – Foreign Key … … 76 76 * attended 77 77 78 == Subject_Course==78 === Subject_Course === 79 79 * '''id_subject*''' – Foreign Key 80 80 * '''id_Course*''' – Foreign Key 81 81 82 == Course_Assignment==82 === Course_Assignment === 83 83 * '''id_Course*''' – Foreign Key 84 84 * '''id_assignment*''' – Foreign Key 85 85 86 == Course_Class==86 === Course_Class === 87 87 * '''id_Course''' – Primary Key 88 88 * '''id_class''' – Primary Key
