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