School_DB

테이블 (5)

Class (Untitled)

  • C_ID (Class ID) — INT — 기본 키 — NOT NULL
  • S_ID (Student_ID) — INT — 외래 키 → Student(학생).S_ID — NOT NULL
  • P_ID (Key) — 외래 키 → Professor.P_ID — NOT NULL
  • NAME (Field)
  • Field2
  • Field3
  • Field4

Enrollemnt (Untitled3)

  • Field

Professor (Untitled2)

  • P_ID (Key) — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Student(학생)

  • S_ID (Student_ID) — INT — 기본 키 — NOT NULL
  • NAME (Student Name) — VARCHAR(50)
  • Field2
  • Field3
  • Field4

Untitled4

  • Field
  • Field2
  • Field3
  • Field4
  • Field5