11913007_과제 3

테이블 (7)

Depasrtment

  • dno — VARCHAR2 (50) — 기본 키 — NOT NULL
  • dname — VARCHAR2 (50)
  • office — VARCHAR2 (50)
  • ssn — VARCHAR2 (50) — 외래 키 → Professor.ssn — NOT NULL

Graduate

  • ssn — VARCHAR2 (50) — 기본 키 — NOT NULL
  • age — INT
  • deg_prog — VARCHAR2 (50)
  • name — VARCHAR2 (50)
  • dno — VARCHAR2 (50) — 외래 키 → Depasrtment.dno — NOT NULL
  • graduatessn — VARCHAR2 (50) — 외래 키 → Graduate.ssn — NOT NULL

Professor

  • ssn — VARCHAR2 (50) — 기본 키 — NOT NULL
  • name — VARCHAR2 (50)
  • age — INT
  • rank — VARCHAR2 (50)
  • speciality — VARCHAR2 (50)

Project

  • pid — VARCHAR2 (50) — 기본 키 — NOT NULL
  • sponsor — VARCHAR2 (50)
  • start_date — DATE
  • end_date — DATE
  • budget — INT
  • ssn — VARCHAR2 (50) — 외래 키 → Professor.ssn — NOT NULL

Work_Prog (Work_prog)

  • ssn — VARCHAR2 (50) — 외래 키 → Graduate.ssn — NOT NULL
  • pid — VARCHAR2 (50) — 외래 키 → Project.pid — NOT NULL

Work_dept

  • ssn — VARCHAR2 (50) — 외래 키 → Professor.ssn — NOT NULL
  • dno — VARCHAR2 (50) — 외래 키 → Depasrtment.dno — NOT NULL
  • pct_time (Field) — VARCHAR2 (50)

Work_in

  • ssn — VARCHAR2 (50) — 외래 키 → Professor.ssn — NOT NULL
  • pid — VARCHAR2 (50) — 외래 키 → Project.pid — NOT NULL