Database

Tables (4)

Professor

  • profid (ssn) — integer — Primary key — NOT NULL
  • profname — varchar(30)
  • age — integer
  • position (rank) — integer
  • research_field (speciality) — varchar(40)

department (dept)

  • department_number (dno) — integer — Primary key — NOT NULL
  • department_name (dname) — varchar(40)
  • departmant_office (office) — varchar(35)

graduate_students (greaduate)

  • ID (ssn) — integer — Primary key — NOT NULL
  • name — varchar(29)
  • age — integer
  • degree_course (deg_prog) — varchar(25)

project

  • project_number (pid) — integer — Primary key — NOT NULL
  • support_organisation (sponsor) — varchar(45)
  • start_date — date
  • budget — integer