College

Tables (4)

Assignment (Untitled4)

  • Num (Field) — Number — Primary key — NOT NULL
  • ID (Field5) — Number — Foreign key → Professor.ID — NOT NULL
  • ID (Field6) — Number — Foreign key → Graduate.ID — NOT NULL
  • ID (Field42) — Number — Foreign key → Graduate.ID — NOT NULL
  • Agency (Field1) — String
  • Date (Field2) — Date
  • Dated (Field3) — Date
  • Money (Field4) — Number

Graduate (Untitled3)

  • ID (Field) — Number — Primary key — NOT NULL
  • ID (Field4) — Number — Foreign key → Major.ID — NOT NULL
  • Name (Field1) — String
  • Age (Field2) — Number
  • Degree (Field3) — String

Major (Untitled2)

  • ID (Field) — Number — Primary key — NOT NULL
  • Name (Field1) — String
  • Office (Field2) — String

Professor (Untitled)

  • ID (Field) — Number — Primary key — NOT NULL
  • Name (Field1) — String
  • Age (Field2) — Number
  • Position (Field3) — String
  • Study (Field4) — String