dsu_university

Tables (4)

department (dept)

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

graduatestu (graduate)

  • graduateid (ssn) — integer — Primary key — NOT NULL
  • graduate_name (name) — varchar(40)
  • graduate_age (age) — integer
  • degree_course (deg_prog) — varchar(30)

professor

  • profid (ssn) — integer — Primary key — NOT NULL
  • name — varchar(40)
  • age — integer
  • position (rank) — varchar(50)
  • research (speciality) — varchar(40)

project

  • projectid (pid) — integer — Primary key — NOT NULL
  • support_org (sponsor) — varchar(40)
  • start_date — date
  • end_date — date
  • budget — varchar(20)