Friday

Tables (7)

Assignments

  • assignment_id — INT — Primary key
  • class_id — INT — Foreign key → Classes.class_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • due_date — DATE
  • class_id (class_id2) — INT — Foreign key → Classes.class_id
  • instructor_id (instructor_id2) — INT — Foreign key → Classes.instructor_id
  • course_id (course_id2) — INT — Foreign key → Classes.course_id

Classes

  • class_id — INT — Primary key
  • 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
  • instructor_id (instructor_id2) — INT — Foreign key → Instructors.instructor_id
  • course_id (course_id2) — INT — Foreign key → Courses.course_id

Courses

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

Enrollments

  • enrollment_id — INT — Primary key
  • class_id — INT — Foreign key → Classes.class_id — NOT NULL
  • enrolled_at — DATE — NOT NULL
  • student_id (student_id2) — INT — Foreign key → Students.student_id
  • student_id — INT — Foreign key → Students.student_id
  • class_id (class_id2) — INT — Foreign key → Classes.class_id
  • instructor_id (instructor_id2) — INT — Foreign key → Classes.instructor_id
  • course_id (course_id2) — INT — Foreign key → Classes.course_id

Instructors

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

Students

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

Submissions

  • submission_id — INT — Primary key
  • assignment_id — INT — Foreign key → Assignments.assignment_id — NOT NULL
  • submitted_at — DATETIME
  • grade — DECIMAL(5,2)
  • student_id (student_id2) — INT — Foreign key → Students.student_id
  • student_id — INT — Foreign key → Students.student_id
  • class_id (class_id2) — INT — Foreign key → Assignments.class_id
  • instructor_id (instructor_id2) — INT — Foreign key → Assignments.instructor_id
  • course_id (course_id2) — INT — Foreign key → Assignments.course_id
  • assignment_id (assignment_id2) — INT — Foreign key → Assignments.assignment_id