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