DSU University

Tables (4)

Graduate students (graduate)

  • ID (ssn) — Primary key — NOT NULL
  • name
  • age
  • degree course (deg_prog) — master / doctor

Professor (professor)

  • ID (ssn) — Primary key — NOT NULL
  • name
  • age
  • position (rank)
  • research field (specialitty)

department (dept)

  • department number (dno) — Primary key — NOT NULL
  • ID (ssn) — Foreign key → Professor.ID — NOT NULL
  • department name (dname)
  • department office (office)

project

  • project number (pid) — Primary key — NOT NULL
  • support organization (sponsor)
  • start date (start_date)
  • end date (end_date)