University

Tables (4)

Department (Untitled2)

  • Key (dno) — Int — Primary key — NOT NULL
  • dname (Field) — String
  • office (Field2) — Int

Graduate (Untitled3)

  • Key (ssn) — String — Primary key — NOT NULL
  • name (Field) — String
  • age (Field2) — Int
  • deg_prog (Field3) — String

Professor (Untitled)

  • Key (ssn) — String — Primary key — NOT NULL
  • name (Field) — String
  • age (Field2) — Int
  • rank (Field3) — String
  • Speciality (Field4) — String

Project (Untitled4)

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