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