ERD_DIAGRAM

Tables (7)

Project_team

  • PK (project_team_id) — NOT NULL — Primary key — NOT NULL
  • Field (team_name) — NULL
  • Field (project_subject) — NULL
  • Field (project_name) — NULL
  • Field (project_score) — NULL

Student

  • PK (student_account) — NOT NULL — Primary key — NOT NULL
  • Field (student_name) — NULL
  • Field (student_hp) — NULL
  • Field (student_age) — NULL
  • Field (student_gender) — NULL
  • Field (student_curriculum) — NULL
  • Field (student_group) — NULL
  • FK (group_teacher_id) — NOT NULL — Foreign key → Teacher.PK — NOT NULL
  • FK (student_region) — NOT NULL — Foreign key → region.PK — NOT NULL
  • FK (project_team_id) — NOT NULL — Foreign key → Project_team.PK — NOT NULL

Teacher

  • PK (teacher_id) — NOT NULL — Primary key — NOT NULL
  • Field (teacher_name) — NULL
  • Field (teacher_hp) — NULL

algorithm_grade

  • PK (student_account) — NOT NULL — Foreign key → Student.PK — NOT NULL
  • Field (algorithm_grade) — NULL
  • Field (algorithm_acquisition_date) — NULL

attendance

  • PK (attendance_id) — NOT NULL — Primary key — NOT NULL
  • Field (attendance_date) — NULL
  • Field (attendance_check) — NULL
  • Field (attendance_sign_in) — NULL
  • Field (attendance_sign_out) — NULL
  • FK (student_account) — NOT NULL — Foreign key → Student.PK — NOT NULL

exam_grade

  • PK (student_account) — NOT NULL — Foreign key → Student.PK — NOT NULL
  • Field (grade_first_exam) — NULL
  • Field (grade_second_exam) — NULL
  • Field (grade_third_exam) — NULL

region

  • PK (region_name) — NOT NULL — Primary key — NOT NULL