ERD

Tables (3)

COURSE

  • Key (Course_ID) — Primary key — NOT NULL
  • Field (Title)
  • Field (Credit)

ENROLLMENT (Untitled3)

  • Key (Student_ID) — Primary key — NOT NULL
  • Key (Course_ID) — Primary key — NOT NULL
  • Key (Student_ID2) — Foreign key → STUDENT.Key — NOT NULL
  • Key (Course_ID2) — Foreign key → COURSE.Key — NOT NULL

STUDENT

  • Key (Student_ID) — Primary key — NOT NULL
  • Field (Name)
  • Field (Major)