test

Tables (5)

Dept (Untitled)

  • dno (Key) — Primary key — NOT NULL
  • dname (Key2) — Primary key
  • ssn (Key3) — Foreign key → Professor.ssn — NOT NULL
  • office (Field)
  • ssn (Key4) — Foreign key → Graduate.ssn — NOT NULL

Graduate (Untitled3)

  • ssn (Key) — Primary key — NOT NULL
  • name (Field)
  • age (Field2)
  • dpt_prog (Field3)
  • mentos (Key2) — Foreign key → Graduate.ssn — NOT NULL

Professor

  • ssn (Key) — Primary key — NOT NULL
  • name (Field)

Project (Untitled2)

  • pid (Key) — Primary key — NOT NULL
  • sponsor (Field)
  • start_date (Field2)
  • end_date (Field3)
  • budget (Field4)

Work_Dept (Untitled4)

  • pct_time (Field)
  • ssn (Key) — Foreign key → Professor.ssn — NOT NULL