1
Tables (4)
Exam
- exam_id — INT — Primary key
- exam_type — VARCHAR(30)
- exam_date — DATE
Section
- section_id — INT — Primary key
- course_id — INT
- semester — VARCHAR(20)
- year — INT
- instructor — VARCHAR(50)
Student
- student_id — INT — Primary key
- name — VARCHAR(50)
- major — VARCHAR(50)
- grade — INT
TakesExam
- section_id — INT — Foreign key → Section.section_id
- student_id — INT — Foreign key → Student.student_id
- exam_id — INT — Foreign key → Exam.exam_id
- score — INT
- section_id (section_id2) — INT — Foreign key → TakesExam.section_id
- student_id (student_id2) — INT — Foreign key → TakesExam.student_id
- exam_id (exam_id2) — INT — Foreign key → TakesExam.exam_id