절차적_수강신청

테이블 (4)

COURSE (Untitled2)

  • courseid (Key) — 기본 키 — NOT NULL
  • coursename (Field)
  • credit (Field2)
  • department (Field3)
  • professor (Field4)
  • starttime (Field5)
  • endtime (Field6)
  • room (Field7)

ENROLLMENT (Untitled3)

  • enrollmentid (Key) — 기본 키 — NOT NULL
  • studentid (Key2) — 외래 키 → STUDENT.studentid — NOT NULL
  • courseid (Key3) — 외래 키 → COURSE.courseid — NOT NULL
  • semester (Field)

PROFESSOR (Untitled4)

  • professorid (Key) — 기본 키 — NOT NULL
  • name (Field)
  • department (Field2)
  • office (Field3)
  • Field4

STUDENT (Untitled)

  • studentid (Key) — 기본 키 — NOT NULL
  • name (Field)
  • email (Field2)
  • major (Field3)
  • year (Field4)