= Database Schema =

= Entities =
== User ==
 * '''id_user''' – Primary Key  
 * username  
 * password  
 * email  
 * created_at  

== Administration ==
 * '''id_user*''' – Foreign Key  
 * department  

== Teacher ==
 * '''id_user*''' – Foreign Key  
 * '''id_teacher''' – Primary Key  
 * hire_date  
 * department  

== Rating ==
 * '''id_rating''' – Primary Key  
 * rating  
 * explanation  
 * '''id_teacher*''' – Foreign Key  
 * '''id_student*''' – Foreign Key  

== Subject ==
 * '''id_subject''' – Primary Key  
 * name  
 * description  

== Course ==
 * '''id_Course''' – Primary Key  
 * num_of_classes  
 * created_by  

== Class ==
 * '''id_class''' – Primary Key  
 * start_time  
 * end_time  
 * duration  
 * '''teacher_id*''' – Foreign Key  
 * '''id_attendance*''' – Foreign Key  

== Student ==
 * '''id_student''' – Primary Key  
 * progress_score  

== Assignment ==
 * '''id_assignment''' – Primary Key  
 * description  
 * score  
 * deadline  

= Relations =

== Enrollment ==
 * '''id_enrollment*''' – Primary Key  
 * '''id_student*''' – Foreign Key  
 * '''id_Course*''' – Foreign Key  
 * status  
 * en_date  

== Submission ==
 * '''id_submission*''' – Primary Key  
 * '''id_student*''' – Foreign Key  
 * '''id_assignment*''' – Foreign Key  
 * submitted_at  
 * progress_score  

== Attendance ==
 * '''id_attendance''' – Primary Key  
 * '''id_student*''' – Foreign Key  
 * '''id_class*''' – Foreign Key  
 * attended  

== Subject_Course ==
 * '''id_subject*''' – Foreign Key  
 * '''id_Course*''' – Foreign Key  

== Course_Assignment ==
 * '''id_Course*''' – Foreign Key  
 * '''id_assignment*''' – Foreign Key  

== Course_Class ==
 * '''id_Course''' – Primary Key  
 * '''id_class''' – Primary Key