6

Tables (7)

Dept

  • dno — Primary key — NOT NULL
  • dname
  • office
  • ssn — Foreign key → Professor.ssn — NOT NULL

Graduate

  • ssn — Primary key — NOT NULL
  • name
  • age
  • deg_prog
  • dno — Foreign key → Dept.dno — NOT NULL
  • ssn (ssn2) — Foreign key → Graduate.ssn — NOT NULL

Professor

  • ssn — Primary key — NOT NULL
  • name
  • age
  • rank
  • speciality

Project

  • pid — Primary key — NOT NULL
  • sponsor
  • start_date
  • end_date
  • budget
  • ssn — Foreign key → Professor.ssn — NOT NULL

Work_Dept

  • ssn — Foreign key → Professor.ssn — NOT NULL
  • dno — Foreign key → Dept.dno — NOT NULL
  • pct_time

Work_In

  • ssn — Foreign key → Professor.ssn — NOT NULL
  • pid — Foreign key → Project.pid — NOT NULL

Work_Prog

  • ssn — Foreign key → Graduate.ssn — NOT NULL
  • pid — Foreign key → Project.pid — NOT NULL