Ryu

Tables (4)

Graduate (Untitled3)

  • ssn (Key) — Primary key — NOT NULL
  • name (Field)
  • age (Field2)
  • deg_prog (Field3)
  • dno (Key2) — Foreign key → debt.dno — NOT NULL
  • pid (Key3) — Foreign key → Project.pid — NOT NULL

Project (Untitled4)

  • pid (Key) — Primary key — NOT NULL
  • spoonser (Field)
  • start_date (Field2)
  • end_date (Field3)
  • budget (Field4)
  • ssn (Key2) — Foreign key → professor.ssn — NOT NULL
  • ssn (Key3) — Foreign key → Graduate.ssn — NOT NULL

debt (Untitled2)

  • dno (Key) — Primary key — NOT NULL
  • dname (Field)
  • office (Field2)
  • ssn (Key2) — Foreign key → professor.ssn — NOT NULL
  • ssn (Key3) — Foreign key → Graduate.ssn — NOT NULL

professor (Untitled)

  • ssn (Key) — Primary key — NOT NULL
  • name (Field2)
  • age (Field3)
  • rank (Field4)
  • age (Field5)
  • speciality (Field6)
  • dno (Key2) — Foreign key → debt.dno — NOT NULL
  • pid (Key3) — Foreign key → Project.pid — NOT NULL