MADANG

Tables (11)

Untitled (Professor)

  • Key (ssn) — VARCHAR(20) — Primary key — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL
  • Field2 (age) — INTEGER — NOT NULL
  • Field3 (rank) — VARCAHR(20) — NOT NULL
  • Field4 (speciality) — VARCHAR(50) — NOT NULL

Untitled (Department)

  • Key (dno) — INTEGER — Primary key — NOT NULL
  • Field (dname) — VARCHART(20) — NOT NULL
  • Field2 (office) — VARCHART(20) — NOT NULL

Untitled (Graduate)

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

Untitled (Project)

  • Key (pid) — Primary key — NOT NULL
  • Key (ssn) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn2) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (sponsor)
  • Field2 (start_date)
  • Field3 (end_date)
  • Field4 (budget)

Untitled (major)

  • Key (dno) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled (run)

  • Field — NOT NULL
  • Key (ssn) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL

Untitled (manage)

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

Untitled (work-dept)

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

Untitled (advisor)

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

Untitled (work-in)

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

Untitled (work-prog)

  • Key (ssn) — Foreign key → Untitled.Key — NOT NULL
  • Key (dno) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Key (pid) — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn2) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (ssn22) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL