Friday

Tables (7)

Assignments

  • Key4 — Primary key — NOT NULL
  • assignment_id — INT
  • class_id — INT — Foreign key → Classes.class_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • due_date — DATE
  • Key — Foreign key → Classes.Key — NOT NULL
  • Key (Key2) — Foreign key → Classes.Key — NOT NULL
  • Key3 — Foreign key → Classes.Key3 — NOT NULL

Classes

  • Key3 — Primary key — NOT NULL
  • class_id — INT
  • course_id — INT — Foreign key → Courses.course_id — NOT NULL
  • instructor_id — INT — Foreign key → Instructors.instructor_id
  • cohort — VARCHAR(50) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • Key — Foreign key → Instructors.Key — NOT NULL
  • Key (Key2) — Foreign key → Courses.Key — NOT NULL

Courses

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

Enrollments

  • Key4 — Primary key — NOT NULL
  • enrollment_id — INT
  • class_id — INT — Foreign key → Classes.class_id — NOT NULL
  • student_id — INT — Foreign key → Students.student_id — NOT NULL
  • enrolled_at — DATE — NOT NULL
  • Key — Foreign key → Students.Key — NOT NULL
  • Key (Key2) — Foreign key → Classes.Key — NOT NULL
  • Key (Key22) — Foreign key → Classes.Key — NOT NULL
  • Key3 — Foreign key → Classes.Key3 — NOT NULL

Instructors

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

Students

  • Key — Primary key — NOT NULL
  • student_id — INT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

Submissions

  • Key4 — Primary key — NOT NULL
  • submission_id — INT
  • assignment_id — INT — Foreign key → Assignments.assignment_id — NOT NULL
  • student_id — INT — Foreign key → Students.student_id — NOT NULL
  • submitted_at — DATETIME
  • grade — DECIMAL(5,2)
  • Key — Foreign key → Students.Key — NOT NULL
  • Key (Key2) — Foreign key → Assignments.Key — NOT NULL
  • Key (Key22) — Foreign key → Assignments.Key — NOT NULL
  • Key3 — Foreign key → Assignments.Key3 — NOT NULL
  • Key4 (Key42) — Foreign key → Assignments.Key4 — NOT NULL