ex0430

Tables (7)

Professor

  • ssn — Primary key — NOT NULL
  • name
  • age
  • Field (rank)
  • Field (speciality)

Untitled (Work_Dept)

  • ssn — Foreign key → Professor.ssn — NOT NULL
  • Key (dno) — Foreign key → Untitled2.Key — NOT NULL
  • Field (pct_time)

Untitled (Wokr_Prog)

  • Key (pid) — Foreign key → Untitled2.Key — NOT NULL
  • Key (ssn) — Foreign key → Untitled2.Key — NOT NULL

Untitled (Work_In)

  • Key (pid) — Foreign key → Untitled2.Key — NOT NULL
  • ssn — Foreign key → Professor.ssn — NOT NULL

Untitled2 (Dept)

  • Key (dno) — Primary key — NOT NULL
  • Field (dname)
  • Field (office)
  • ssn — Foreign key → Professor.ssn — NOT NULL

Untitled2 (Project)

  • Key (pid) — Primary key — NOT NULL
  • Field (spnosor)
  • Field (start_date)
  • Field (end_date)
  • Field (budget)
  • ssn — Foreign key → Professor.ssn — NOT NULL

Untitled2 (Graduate)

  • Key (ssn) — Primary key — NOT NULL
  • Field (name)
  • Field (age)
  • Field (deg_prog)
  • Key (dno) — Foreign key → Untitled2.Key — NOT NULL
  • Key (mentor) — Foreign key → Untitled2.Key — NOT NULL