erd

Tables (6)

Enrollment (Untitled5)

  • student_id (pk + FK)
  • lecture_id (PK + FK)
  • grade (Field3)

Instructor (Untitled)

  • instructor_id (Key) — INT — Primary key — NOT NULL
  • name (Field)
  • age (Field2)
  • gender (Field3)

Lecture (Untitled4)

  • lecture_time (Field)
  • location (Field2)
  • Field3
  • Field4
  • Field5

Notice (Untitled6)

  • title (Field)
  • content (Field2)
  • created_at (Field3)
  • instructor_id (Field4)
  • lecture_id (FK)
  • notice_id (PK)

Student (Untitled2)

  • name (Field)
  • address (Field2)
  • student_id (Field3)

Subject (Untitled3)

  • subject_name (Field)
  • subject_id (PK)