과제

테이블 (7)

Dept (dept)

  • ssn — VARCHAR(20) — 기본 키 — NOT NULL
  • dno — INT(11)
  • dname — VARCHAR(20)
  • office — VARCHAR(20)

Graduate (graduate)

  • dno — INT(11) — 기본 키 — NOT NULL
  • graduatessn — VARCHAR(20) — 기본 키 — NOT NULL
  • ssn — VARCHAR(20)
  • name — VARCHAR(20)
  • age — INT(11)
  • deg_prog — INT(11)
  • dno (dno2) — INT(11) — 외래 키 → Graduate.dno — NOT NULL
  • graduatessn (graduatessn2) — VARCHAR(20) — 외래 키 → Graduate.graduatessn — NOT NULL

Professor (professor)

  • name — VARCHAR(20)
  • age — INT(11)
  • rank — VARCHAR(20)
  • speciality — VARCHAR(20)
  • ssn — VARCHAR(20)

Project (project)

  • ssn — VARCHAR(20) — 기본 키 — NOT NULL
  • pid — INT(11)
  • sponsor — VARCHAR(20)
  • start_date — INT(11)
  • end_date — INT(11)
  • budget — INT(50)

Work_Dept (work_dept)

  • ssn — VARCHAR(20) — 외래 키 → Dept.ssn — NOT NULL
  • pct_time — INT(11)
  • dno — INT(11)

Work_In (work_in)

  • ssn — VARCHAR(20) — 외래 키 → Project.ssn — NOT NULL

Work_Prog (work_prog)

  • ssn — VARCHAR(20) — 기본 키 — NOT NULL
  • pid — INT(11) — 기본 키 — NOT NULL
  • ssn (ssn2) — VARCHAR(20) — 외래 키 → Project.ssn — NOT NULL
  • dno (dn) — INT(11) — 외래 키 → Graduate.dno — NOT NULL
  • graduatessn (gs) — VARCHAR(20) — 외래 키 → Graduate.graduatessn — NOT NULL