= 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  

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

=== 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   

=== 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  

== Sql ==

[attachment:PT_add_data.sql]

[attachment:DML_PT.sql]