DB종합실습1
테이블 (4)
Untitled (enrollments)
- Key (enrollment_id) — 기본 키 — NOT NULL
- student_id — 외래 키 → students.student_id — NOT NULL
- Key (course_id) — 외래 키 → courses.Key — NOT NULL
- Field (enroll_date)
- Field (grade)
courses
- Key (course_id) — 기본 키 — NOT NULL
- Key (professor_id) — 외래 키 → professors.Key — NOT NULL
- Field (title)
- Field (credits)
professors
- Key (professor_id) — 기본 키 — NOT NULL
- Field (name)
- Field (office)
- Field (phone)
students
- student_id — 기본 키 — NOT NULL
- name
- major
- phone