madanguniv1

Tables (4)

Dept (Untitled)

  • dno (Key) — Primary key — NOT NULL
  • dname (Field)
  • office (Field2)
  • id (Key2) — Foreign key → Professor.id — NOT NULL

Professor

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • age (Field2)
  • rank (Field3)
  • specialty (Field4)

Untitled3

  • pid (Field) — Primary key
  • sponsor (Field2)
  • budget (Field3)
  • start_date (Field4)
  • end_date (Field5)

graduate (Untitled2)

  • ssn (Field) — Primary key
  • name (Field2)
  • age (Field3)
  • deg_prog (Field4)