4

Tables (7)

Assignments

  • assignment_id — INT
  • class_id — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • due_date — DATE

Classes

  • class_id — INT
  • course_id — INT — NOT NULL
  • instructor_id — INT
  • cohort — VARCHAR(50) — NOT NULL
  • start_date — DATE
  • end_date — DATE

Courses

  • course_id — INT
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT

Enrollments

  • enrollment_id — INT
  • class_id — INT — NOT NULL
  • student_id — INT — NOT NULL
  • enrolled_at — DATE — NOT NULL

Instructors

  • instructor_id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • specialty — VARCHAR(100)

Students

  • student_id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • cohort — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

Submissions

  • submission_id — INT
  • assignment_id — INT — NOT NULL
  • student_id — INT — NOT NULL
  • submitted_at — DATETIME
  • grade — DECIMAL(5,2)