ㅁㄴㅇㄹ

Tables (4)

COURSES (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • COURSE_NAME (Field)
  • MAJOR_ID (Key2) — Foreign key → MAJORS.ID — NOT NULL

ENROLLMENTS (Untitled4)

  • ID (Key) — Primary key — NOT NULL
  • COURSE_ID (Key2) — Foreign key → COURSES.ID — NOT NULL
  • STUDENT_ID (Key3) — Foreign key → STUDENTS.ID — NOT NULL

MAJORS (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • MAJOR_NAME (Field)

STUDENTS (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • GRADE (Field3)
  • NAME (Field)
  • MAJOR_ID (Key2) — Foreign key → MAJORS.ID — NOT NULL