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

kreiranje.sql

DML_PT.sql​