erd_practice

Tables (4)

Class (Untitled4)

  • Class_No (Field) — INT — Primary key
  • Region (Field2) — Varchar
  • Consultant_ID (Field3) — INT
  • Coach_ID (Field4) — INT

Coach (Untitled3)

  • Coach_ID (Field) — INT — Primary key
  • Class_No (Field3) — INT — Foreign key → Class.Class_No

Consultant (Untitled2)

  • Consultant_ID (Field) — INT — Primary key
  • Class_No (Field3) — INT — Foreign key → Class.Class_No

Student (Untitled)

  • No (Field) — INT — Primary key
  • Class_No (Field6) — INT — Foreign key → Class.Class_No
  • CS (Field2) — Boolean
  • Retire (Field3) — Boolean
  • Gisu (Field4) — INT
  • Course (Field5) — Varchar