homework1

Tables (5)

class (Untitled3)

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Key (Key3) — Foreign key → course.Key — NOT NULL
  • Key (Key4) — Foreign key → professor.Key — NOT NULL
  • Key (Key22) — Foreign key → professor.Key — NOT NULL
  • Field
  • Field2
  • Field3

course (Untitled4)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

department (Untitled2)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

professor (Untitled5)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → department.Key — NOT NULL
  • Field
  • Field2
  • Field3

student (Untitled)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → department.Key — NOT NULL
  • Key (Key3) — Foreign key → class.Key — NOT NULL
  • Key2 (Key22) — Foreign key → class.Key2 — NOT NULL
  • Key (Key32) — Foreign key → class.Key — NOT NULL
  • Key (Key4) — Foreign key → class.Key — NOT NULL
  • Key (Key222) — Foreign key → class.Key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4