DSUuniversity

Tables (5)

customer

  • custid — integer — Primary key — NOT NULL
  • Field
  • Field2

department

  • department_no — integer — Primary key — NOT NULL
  • department_name — varchar(20)
  • department_office — varchar(40)
  • professor_id — integer — Foreign key → professor.professor_id — NOT NULL
  • department_no (department_no2) — integer — Foreign key → professor.department_no — NOT NULL

graduate_students

  • grad_id — integer — Primary key — NOT NULL
  • grad_name — varchar(40)
  • grad_age — integer
  • grad_degree_course — varchar(20)

professor

  • professor_id — integer — Primary key — NOT NULL
  • department_no — integer — Foreign key → department.department_no — NOT NULL
  • professor_name — varchar(40)
  • professor_age — integer
  • position — varchar(20)
  • research_field — varchar(60)

project

  • project_id — integer — Primary key — NOT NULL
  • sponsor (sponser) — varchar(20)
  • start_date — varchar(40)
  • end_date — varchar(40)
  • budget — varchar(20)