Howon

Tables (7)

Deparment (Department)

  • Dno — INT — Primary key — NOT NULL
  • dname — VARCHAR(40)
  • office — VARCHAR(40)
  • SSN — INT
  • SSN (SSN2) — INT — Foreign key → Professor.SSN

Graduate

  • SSN — INT — Primary key — NOT NULL
  • G_Name — VARCHAR(40)
  • G_Age — INT
  • Deg_pro — INT
  • Dno — INT
  • SSN (SSN2) — INT
  • Dno (Dno2) — INT — Foreign key → Deparment.Dno — NOT NULL
  • SSN (SSN3) — INT — Foreign key → Graduate.SSN — NOT NULL

Professor (prof)

  • SSN — INT — Primary key
  • P_Name (program_id) — VARCHAR(40)
  • P_Age — INT
  • Speciality — VARCHAR(40)
  • Field (Rank) — VARCHAR(40)

Project

  • PID (Pid) — INT — Primary key — NOT NULL
  • SPONSOR (Sponsor) — VARCHAR(40)
  • start_date — DATE
  • end_date — DATE
  • budget — INT
  • SSN — INT
  • SSN (SSN2) — INT — Foreign key → Professor.SSN

Work Prog (Work prog)

  • Pid — INT — Primary key — NOT NULL
  • SSN — INT
  • PID (Pid2) — INT — Foreign key → Project.PID — NOT NULL
  • SSN (SSN2) — INT — Foreign key → Graduate.SSN — NOT NULL

Work dept

  • SSN — INT — Primary key — NOT NULL
  • Dno — INT
  • Pct_time — INT
  • SSN (SSN2) — INT — Foreign key → Professor.SSN
  • Dno (Dno2) — INT — Foreign key → Deparment.Dno — NOT NULL

Work in

  • SSN — INT — Primary key — NOT NULL
  • PID (Pid) — INT
  • SSN (SSN2) — INT — Foreign key → Professor.SSN
  • PID (Pid2) — INT — Foreign key → Project.PID — NOT NULL