Class250430

Tables (7)

Untitled (Professor)

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

Untitled (Dept)

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

Untitled (Project)

  • Key (pid) — Primary key — NOT NULL
  • Field (sponsor)
  • Field (start_date)
  • Field (edn_date)
  • Field (budget)
  • Key (ssn) — Foreign key → Untitled.Key — NOT NULL

Untitled (Graduate)

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

Untitled (Work_Dept)

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

Untitled (Work_Prog)

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

Untitled (Work_In)

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