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