Madang_univ

Tables (7)

Department (Untitled2)

  • dno (Field) — int — Primary key — NOT NULL
  • dname (Field2) — varchar(40) — NOT NULL
  • office (Field3) — varchar(20)
  • dept_head (Field4) — int — Foreign key → Professor.ssn — NOT NULL

Graduate (Untitled3)

  • ssn (Field) — varchar(40) — Primary key — NOT NULL
  • name (Field2) — varchar(40) — NOT NULL
  • age (Field3) — tinyint
  • deg_prog (Field4) — char(2) — NOT NULL
  • major (Field5) — int — Foreign key → Department.dno — NOT NULL
  • advisor (Field7) — varchar(40) — Foreign key → Graduate.ssn

Professor (Untitled)

  • ssn (Field) — varchar(40) — Primary key — NOT NULL
  • name (Field2) — varchar(40) — NOT NULL
  • age (Field3) — tinyint
  • rank (Field4) — varchar(20)
  • specialty (Field5) — varchar(20)

Project (Untitled4)

  • pid (Field) — int — Primary key — NOT NULL
  • sponsor (Field2) — varchar(40)
  • start_date (Field3) — date
  • end_date (Field4) — date
  • budget (Field5) — int — NOT NULL
  • manager (Field6) — varchar(40) — Foreign key → Professor.ssn — NOT NULL

work-in (Untitled5)

  • p_ssn (Field3) — varchar(40) — Foreign key → Professor.ssn — NOT NULL
  • pid (Field) — int — Foreign key → Project.pid — NOT NULL

work_dept (Untitled6)

  • p_ssn (Field3) — varchar(40) — Foreign key → Professor.ssn — NOT NULL
  • dno (Field) — int — Foreign key → Department.dno — NOT NULL
  • pct_time (Field2) — int

work_prog (Untitled7)

  • g_ssn (Field) — varchar(40) — Foreign key → Graduate.ssn — NOT NULL
  • pid (Field2) — int — Foreign key → Project.pid — NOT NULL