9주차 예시2

테이블 (7)

Untitled (professor)

  • Key (ssn) — 기본 키 — NOT NULL
  • Field (name)
  • Field (age)
  • Field (rank)
  • Field2 (speciality)

Untitled (Dept)

  • Key (dno) — 기본 키 — NOT NULL
  • Field (dname)
  • Field (office)
  • Key (ssn) — 외래 키 → Untitled.Key — NOT NULL

Untitled (project)

  • Key (pid) — 기본 키 — NOT NULL
  • Field (sponsor)
  • Field (start_date)
  • Field (edn_date)
  • Field (budget)
  • Key (ssn) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Graduate)

  • Key (ssn) — 기본 키 — NOT NULL
  • Field (name)
  • Field (age)
  • Field (deg_prog)
  • Key (dno) — 외래 키 → Untitled.Key — NOT NULL
  • Key (mentor) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Work_Dept)

  • Key (ssn) — 외래 키 → Untitled.Key — NOT NULL
  • Key (dno) — 외래 키 → Untitled.Key — NOT NULL
  • Field (pct_time)

Untitled (Work_Prog)

  • Key (ssn) — 외래 키 → Untitled.Key — NOT NULL
  • Key (pid) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Work_In)

  • Key (ssn) — 외래 키 → Untitled.Key — NOT NULL
  • Key (pid) — 외래 키 → Untitled.Key — NOT NULL