ㅁㄴㅇㄹ
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