과제

테이블 (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)