University

Tables (7)

Department

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

Graduate

  • SSN — INT — Primary key — NOT NULL
  • G_Name — Vachar(40)
  • G_Age — INT
  • Deg_pro — INT
  • Dno — INT — Foreign key → Department.Dno — NOT NULL
  • SSN (SSN2) — INT — Foreign key → Graduate.SSN — NOT NULL

Professor

  • SSN — INT — Primary key — NOT NULL
  • P_Name — Vachar(40)
  • P_Age — INT
  • Speciality — Vachar(40)
  • Field (Rank) — Vachar(40)

Project

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

Work Prog (Work prog)

  • Pid — INT — Foreign key → Project.Pid — NOT NULL
  • SSN — INT — Foreign key → Graduate.SSN — NOT NULL

Work dept

  • SSN — INT — Foreign key → Professor.SSN — NOT NULL
  • Dno — INT — Foreign key → Department.Dno — NOT NULL
  • Pct_time — INT

Work in

  • SSN — INT — Foreign key → Professor.SSN — NOT NULL
  • Pid — INT — Foreign key → Project.Pid — NOT NULL