EASY

Tables (3)

PROF (Professor)

  • id — char(2) — Primary key — NOT NULL
  • name — nchar(10)

Student

  • Key (id) — char(2) — Primary key — NOT NULL
  • Field (name) — nchar(5)

Untitled (sugang)

  • id (pid) — char(2) — Foreign key → PROF.id — NOT NULL
  • Key (sid) — char(2) — Foreign key → Student.Key — NOT NULL
  • Field (grade) — char(2)