TEST

Tables (4)

CLASS

  • ID (CLASS_ID) — INT — Primary key — NOT NULL
  • NAME (CLASS_NAME) — VARCHAR

CLASS (CLASS2)

  • NAME (CLASS_NAME) — VARCHAR — Primary key — NOT NULL

STUDENT

  • ID (STUDENT_ID) — INT — Primary key — NOT NULL
  • CLASS (CLASS_ID) — INT — Foreign key → CLASS.ID — NOT NULL
  • NAME (STUDENT_NAME) — VARCHAR

STUDENT (STUDENT2)

  • NAME (STUDENT_NAME) — VARCHAR — Primary key — NOT NULL
  • NAME (CLASS_NAME) — VARCHAR — Foreign key → CLASS.NAME — NOT NULL