bootcamp_erd

Tables (7)

Assignments

  • assignment_id — INT — Primary key
  • offering_id — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • due_date — DATE

Course_Offerings

  • offering_id — INT — Primary key
  • course_id — INT — NOT NULL
  • instructor_id — INT — NOT NULL
  • cohort — VARCHAR(50) — NOT NULL
  • start_date — DATE
  • end_date — DATE

Courses

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

Enrollments

  • enrollment_id — INT — Primary key
  • offering_id (offering_id2) — INT — Foreign key → Course_Offerings.offering_id
  • student_id (student_id2) — INT — Foreign key → Students.student_id
  • enrolled_at — DATE — NOT NULL

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
  • cohort — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

Submissions

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