2
Tables (6)
Course
- course_id — INT — Primary key
- title — VARCHAR(100)
- credits — INT
EnrolledIn
- student_id — INT — Foreign key → Student.student_id
- section_id — INT — Foreign key → Section.section_id
Exam
- exam_id — INT — Primary key
- exam_type — VARCHAR(30)
- exam_date — DATE
- section_id — INT — Foreign key → Section.section_id
ExamScore
- student_id — INT — Foreign key → Student.student_id
- exam_id — INT — Foreign key → Exam.exam_id
- score — INT
Section
- section_id — INT — Primary key
- semester — VARCHAR(20)
- year — INT
- instructor — VARCHAR(50)
- course_id — INT — Foreign key → Course.course_id
Student
- student_id — INT — Primary key
- name — VARCHAR(50)
- major — VARCHAR(50)
- grade — INT