Changes between Initial Version and Version 1 of Relational schema (DDL and Database)


Ignore:
Timestamp:
02/05/25 22:09:15 (2 weeks ago)
Author:
206046
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Relational schema (DDL and Database)

    v1 v1  
     1User (**id_user**, username, password, email, created_at)
     2Administration (department)
     3Teacher (id_teacher, hire_date, department)
     4Rating (id_rating, rating, explanation, id_teacher)
     5Subject (id_subject, name, description)
     6Course (id_Course, num_of_classes, created_by)
     7Class (id_class, start_time, end_time, duration, teacher_id)
     8Student (id_student, progress_score)
     9Enrollment (id_enrollment, id_student, id_Course, status, en_date)
     10Assignment (id_assignment, description, score, deadline)
     11Submission (id_submission, id_student, id_assignment, submitted_at, progress_score)
     12Attendance (id_attendance, id_student, id_class, attended)
     13Subject_Course (id_subject, id_Course)
     14Course_Assignment (id_Course, id_assignment)
     15Course_Class (id_Course, id_class)