과제
테이블 (5)
Class (Untitled3)
- class_id (Key) — 기본 키 — NOT NULL
- professor_id (Key2) — 외래 키 → Professor.professor_id — NOT NULL
- course_id (Key3) — 외래 키 → Course.course_id — NOT NULL
- building (Field3)
- room (Field4)
- day (Field5)
- time_slot (Field6)
Course (Untitled5)
- course_id (Key) — 기본 키 — NOT NULL
- name (Field)
- credits (Field2)
- department (Field3)
Enrollment (Untitled2)
- enrollment_id (Key) — 기본 키 — NOT NULL
- student_id (Key2) — 외래 키 → student.student_id — NOT NULL
- class_id (Key3) — 외래 키 → Class.class_id — NOT NULL
Professor (Untitled4)
- professor_id (Key) — 기본 키 — NOT NULL
- name (Field)
- department (Field2)
student (Untitled)
- student_id (Key) — 기본 키 — NOT NULL
- name (Field)
- department (Field2)