SchoolDB

Tables (3)

CLASS (Untitled2)

  • C_ID (Key2) — INT — Primary key — NOT NULL
  • S_ID (STUDENT ID2) — INT — Foreign key → STUDENT.S_ID — NOT NULL
  • P_ID (Key) — Foreign key → PROFESSOR.P_ID — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

PROFESSOR (Untitled3)

  • P_ID (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

STUDENT (Untitled)

  • S_ID (STUDENT ID) — INT — Primary key — NOT NULL
  • NAME (STUDENT NAME) — VARCHAR(50)
  • Field2
  • Field3
  • Field4
  • Field5